Crystal Reports can this sql work in crystal?

Message

     I tried this in Access and seems to work ok, thought I'd try this in CrystalXI to emulate a Full Outer Join. 
It returns a syntax error (comma) in query expression on the first line.
     - is there a problem, can it be fixed?

SELECT  NZ(`sdscastings`.`Item_No`,`invlisting`.`Item_No`) as [FR/VN]
, `sdscastings`.`Item_Desc`
, `sdscastings`.`Description_Line_2`
, `sdscastings`.`Prime_Vendor`
, `sdscastings`.`Vendor_Product_No`
, `sdscastings`.`Production_Cat`
, `sdscastings`.`Production_Sub_Cat`
FROM   `Sheet1$` `sdscastings` LEFT JOIN `Sheet1$` `invlisting`
ON `sdscastings`.`Item_Desc`= `invlisting`.`Item_Desc`
UNION
SELECT  NZ(`sdscastings`.`Item_No`,`invlisting`.`Item_No`) as [FR/VN]
, 
, `invlisting`.`Description_Line_2`
, `invlisting`.`Prime_Vendor`
, `invlisting`.`Vendor_Product_No`
, `invlisting`.`Production_Cat`
, `invlisting`.`Production_Sub_Cat`
FROM   `Sheet1$` `sdscastings` LEFT JOIN `Sheet1$` `invlisting`
ON `sdscastings`.`Item_Desc`= `invlisting`.`Item_Desc`
I have some other sql stuff in Access, can these be transported accross to Crystal? Or does SQL have different dialects?

btw, Full Outer Joins are not available in this report