I am using VB.NET 2010 Express to query an access mdb database.
I need to join a table like this:
SELECT * FROM
table1 LEFT OUTER JOIN table2 xx ON
table1.cola = xx.cola AND
xx.colb = 8
the xx.colb = 8 part creates an error
I've tried putting the 'xx.colb = 8' part into the WHERE clause but that doesnt produce the same output.