I was given this SQL to help me with a report I am working on in Access. Only thing is this does not seem to be formatted correctly for access SQL. I am receiving errors using this code. Can anybody give me a hand formatting this correctly?
LEFT OUTER JOIN CU ON CU_KEY = IV_CUKEY
LEFT OUTER JOIN MV ON MV_INV_NO = RIGHT('0000000'+ CONVERT(VARCHAR,IV_NUMBER),7)
LEFT OUTER JOIN MX ON MX_SEQNUM = MV_MXSEQNUM