General information
Category:
Coding, syntax & commands
Steve,
You will need to qualify the table names...
SELECT mytable.*;
FROM mytable ;
LEFT JOIN yourtable y1 ON mytable.mydata1 = y1.yourdata1 ;
LEFT JOIN yourtable y2 ON mytable.mydata2 = y2.yourdata2 ;
LEFT JOIN yourtable y3 ON mytable.mydata3 = y3.yourdata3 ;
INTO CURSOR rpt
HTH,
Phil
Is this how?
SELECT *;
FROM mytable ;
LEFT JOIN yourtable ON mytable.mydata1 = yourtable.yourdata1 ;
LEFT JOIN yourtable ON mytable.mydata2 = yourtable.yourdata2 ;
LEFT JOIN yourtable ON mytable.mydata3 = yourtable.yourdata3 ;
INTO CURSOR rpt
Thanks for the info.
Previous
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