|
-
May 25th, 2000, 10:53 PM
#1
Thread Starter
Addicted Member
I am getting an Incorrect syntax near the keyword 'FROM'.
heres the code:
SELECT 'Reciept ID' = Receipt_id, 'Customer Type ID '= Customer_type_id,
FROM database.dbo.vw_receipt_item ri join database.dbo.vw_LaLa l
ON ri.receipt_item_id = l.receipt_item_id
Where created_dt between @TodayDate and @HourBackDate AND Customer_type_id = -1000 or Custome_type_id = -1015
this is directly being done in SQL
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|