i used code internet model of queries stored procedure. uses keyword tab , have no idea does. can explain me?
here code:
select * #dailyreport (select a.customer,b.cust_name, opendt, txdate [date], salesamt daily left outer join customer b on a.customer =b.customer txdate between @begin , @end) tab select * #dailytx (select customer, txdate [date], salestx daily txdate between @begin , @end) tab
this not keyword, alias. user left out keyword (which legal sql , allowed)
select * #dailytx (select customer, txdate [date], salestx daily txdate between @begin , @end) tab
sql server requires sub-queries aliased writter picked first 3 letters of table guess. tmp might have been clearer. variable name.
Comments
Post a Comment