I used the query designer to create the following SELECT statement...

SELECT A.account, A.namekey, A.department,;
A.section, A.team, A.name, A.addr1_1,;
A.addr1_2, A.city1, A.state1, A.zip1_5,;
A.camt0, A.camt1, B.eamt0, B.eamt1,;
B.gemp0, B.gemp1, B.temp0, B.temp1,;
C.cproj, C.eproj, 0000000 AS cpcproj, ;
0000000 AS epcproj;
FROM A LEFT OUTER JOIN B;
LEFT OUTER JOIN C ;
ON A.account = C.account ;
ON A.account = B.account;
WHERE A.department NOT IN ("16","17","18","19","20");
ORDER BY A.account;
INTO TABLE vic

...I need all records from A, and matching records in B and in C. I get all A records just fine, and their matching B records. But, every record in the result set has an identical value in the two C fields (C.cproj, C.eproj). I expected the LEFT OUTER JOIN to get the results I wanted, but why are the C values the same in every record (they are definitely different in the C table.

Thanks!!!