Hi All,

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.

any ideas?

H