Thank you Nick, that worked perfectly. So, what is the difference, I see the difference in the order of the JOIN and ON commands. Are there "rules" for that placement? And, why didn't the query designer do that, or did I choose things in the correct order??


>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;
ON A.account = B.account;
LEFT OUTER JOIN C ;
ON A.account = C.account ;
WHERE A.department NOT IN ("16","17","18","19","20");
ORDER BY A.account;
INTO TABLE vic