Hi, is it possible to use columns using physical table and variable table under where statement?
im getting this errorCode:insert into @tb1( local_off_totmins) select sum(mint_usage) from tblcalllogs a where charge_type='local call' and net_type='offnet' and a.phone_no = tblcalllogs.phone_no
Msg 4104, Level 16, State 1, Line 36
The multi-part identifier "tblcalllogs.phone_no" could not be bound.





Reply With Quote