General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only