e trying to achieve last 6 items joining the tables Cust_Inv and cust_det.
for that you need to do this only
select top 6 order_id as order_id,fname as fname ,lname as lname,order_date as order_date,ord_paid as ord_paid
from Cust_Inv ,cust_det
where cust_det.Cust_Acc_No=Cust_InV.Cust_Acc_No
order by Cust_Inv.INV_No desc
pls try and i hope i understood your prob correctly
Regards,
Vimal Syam.V
Don't forget to click "Mark as Answer" on the post that helped you.
Vimal Syam
Member
30 Points
5 Posts
Re: Error: Invalid column name 'INV_No'.
Aug 14, 2010 06:53 PM|LINK
i think, you ar
e trying to achieve last 6 items joining the tables Cust_Inv and cust_det.
for that you need to do this only
select top 6 order_id as order_id,fname as fname ,lname as lname,order_date as order_date,ord_paid as ord_paid
from Cust_Inv ,cust_det
where cust_det.Cust_Acc_No=Cust_InV.Cust_Acc_No
order by Cust_Inv.INV_No desc
pls try and i hope i understood your prob correctly
Vimal Syam.V
Don't forget to click "Mark as Answer" on the post that helped you.