-
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
-
Try getting rid of the comma after the last field before the word FROM.
-
If you made this Join with the SQL Builder, I suggest next time you make a query in Access and the copy the sql to your vb program. I found a bug in the Joins created by the sql builder of VB6...
