Hi Mark,

What you have done was ok. This is a known bug of the query designer since VFP 3.0 :-((((
So if you have more than 2 tables to join them, you have to do the query by your own.


>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