[SQL2005] Variable Table Insert Select

[jlbantang]

Hi, is it possible to use columns using physical table and variable table under where statement?

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

im getting this error

Msg 4104, Level 16, State 1, Line 36
The multi-part identifier "tblcalllogs.phone_no" could not be bound.

[jggtz]

Don't know if this is the error but You're comparing the field 'phone_no' against itself
'a.phone_no' and table 'tblcalllogs.phone_no' is the same table and the same field
Try next

Insert Into @tb1( local_off_totmins) 
    Select Sum(mint_usage) 
    From   tblcalllogs
    Where  charge_type='local call' and net_type='offnet'