Left Join error

mariakovacs · October 13th, 2003, 03:55 PM

Using VB script in my asp page I am getting an error with this left join statement:

sub db_select_grid_VIPPUserLinks
grid_VIPPUserLinks_sql = "SELECT * FROM VIPP, VIPPUserLinks left join VIPPUserLinks on (VIPP.CustomerID = VIPPUSerLinks.CustomerID) WHERE VIPPUserLinks.user_id = " & user_id & ""

end sub

Error:Microsoft JET Database Engine error '80040e14'
Syntax error in JOIN operation.

Any thoughts on what might be wrong?

Jeff Mason · October 13th, 2003, 04:02 PM

Your SQL should read (you have VIPPUserLinks in there twice):

Code:

SELECT * FROM VIPP left join VIPPUserLinks on (VIPP.CustomerID = VIPPUSerLinks.CustomerID) WHERE VIPPUserLinks.user_id = " & user_id & ""

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

mariakovacs · October 13th, 2003, 04:16 PM

Thank YOU!!!