hi all
i have three table - A with three field (ACode,BCode,CCode) , B with two field (BCode,BName) , C with two field (CCode,CName)
i want to write a SQL that make a cursor with ACode,BCode,CCode,BName,CName for me.
but when i write
SELECT a.acode, a.bcode, a.ccode, b.bname, c.cname;
FROM a LEFT OUTER JOIN b;
LEFT OUTER JOIN c ;
ON a.bcode = b.bcode ;
ON a.ccode = c.ccode;
ORDER BY a.acode into cursor xpx

the query maker send an error to me and say you can not join from a to b,c table.

what must i do?
thanks