What's wrong w/ this Join SQL Statement?

[Bebe]

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

[BruceG]

Try getting rid of the comma after the last field before the word FROM.

[Backbraker]

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...