VB6 and DBF files with outer joins
Posted on 2006-06-21
I have the following query
LEFT OUTER JOIN SHMSTINF ON SHMASTER.NUMBER = SHMSTINF.NUMBER
LEFT OUTER JOIN SHFAMCOD ON SHMSTINF.FAMCODE = SHFAMCOD.FAMCODE
WHERE SHMASTER.NUMBER = 2
For some reason I cannot do 2 left outer joins. Just to give you background SHMSTINF and SHFAMCODE are lookup tables, and for some records they may not have entries. Which is why I'm using Left Outer Joins. If I eliminate one of the left outer joins it works fine. I was really hoping to not have to do this in seperate queries.
Here is the error I receive:
"Syntax error (missing operator) in query expression 'SHMASTER.NUMBER = SHMSTINF.NUMBER LEFT OUTER JOIN SHFAMCOD ON SHMSTINF.FAMCODE = SHFAMCOD.FAMCODE"