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:
If you can help me get the syntax right, I'd be SOOOO happy!
I basically am changing the 'from' section of the SQL statement.
Here is the access version:
Code:
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!