Hi,

the laterst version, the following query not return the correct data:

Select A.Code As A,B.Code As B, C.Code As C
FROM TESTA A
INNER JOIN TESTB B ON (A.Code=B.Code)
LEFT JOIN TESTC C ON (A.Code=C.Code) AND (B.JOB=C.JOB)

looks like join clause not allow to join with more than one table, if I mover join to where clause, it returns correct data:

Select A.Code As A,B.Code As B, C.Code As C
FROM TESTA A
INNER JOIN TESTB B ON (A.Code=B.Code)
LEFT JOIN TESTC C ON (A.Code=C.Code)
WHERE (B.JOB=C.JOB)

Jianfei

Jianfei,

<< the laterst version, the following query not return the correct data:

Select A.Code As A,B.Code As B, C.Code As C
FROM TESTA A
INNER JOIN TESTB B ON (A.Code=B.Code)
LEFT JOIN TESTC C ON (A.Code=C.Code) AND (B.JOB=C.JOB) >>

Please send me the data that you're using.

--
Tim Young
Elevate Software
www.elevatesoft.com