Hi all:
Is there a max joins in Foxpro one can have ?
I have a simple sql statement with five joins and it is giving me syntax error.
Here is the code:

SELECT Ladetail.fcearncode;
FROM m2mdata!ladetail INNER JOIN m2mdata!prempl ;
Left outer JOIN m2mdata!jodrtg ;
INNER JOIN m2mdata!ladetail ;
INNER JOIN m2mdata!jomast ;
INNER JOIN m2mdata!prempl ;
INNER JOIN m2mdata!jodrtg ;
INNER JOIN m2mdata!jomast ;
INNER JOIN m2mdata!inmast ;
ON (Inmast.fpartno) + (Inmast.frev) == (Jomast.fpartrev) + (Jomast.fpartno);
ON Inwork.fcpro_id = Jodrtg.fpro_id ;
ON Prdept.fdeptno = Prempl.fdept ;
ON Jomast.fjobno = Jodrtg.fjobno ;
ON Upper(ladetail.fjobno) + str(ladetail.foperno,4) == upper (jodrtg.fjobno) + str(jodrtg.foperno,4) ;
ON Ladetail.fempno = Prempl.fempno ;
INTO Cursor cAtemp

Thanks