SQL syntax for Crystal

[tmcain]

I need to convert SQL syntax that originated in access to a crystal report. I am not familiar with proper placement of tick marks, etc. and am having problems finding how to do this in help or online.

I basically am changing the 'from' section of the SQL statement.

Here is the access version:

FROM (PROD_TIDWOWRK INNER JOIN PROD_TIDWOTSK ON PROD_TIDWOWRK.WORK_ORDER_NBR = PROD_TIDWOTSK.WORK_ORDER_NBR) LEFT JOIN PROD_TIDSCHRC ON (PROD_TIDWOWRK.KEY_REF_NBR = PROD_TIDSCHRC.REFERENCE_NBR) AND (PROD_TIDWOWRK.KEY_REF_TYPE = PROD_TIDSCHRC.REFERENCE_TYPE)

If you can help me get the syntax right, I'd be SOOOO happy!

 

[tmcain]

Additional info, the database is Oracle 8.16

 

[chelseatech]

Just use the Visual linking Expert inside CR and let it build the joins for you. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[tmcain]

Sorry, already tried that one and it doesn't work. I was going to do it manually.