joining 3 tables (access database)

good day! i need help on joing tables using access database.

whenere i join 2 tables, there is no problem, but when joining 3 tables i always get this error:

Syntax error (missing operator) in query expression 'a.PO_NUMBER=c.PO_NUMBER INNER JOIN MGOCMGR_MGC_PAYMENT_TERM_MASTER d ON c.PO_PAYMENT_TERM_CODE=d.PAYMENT_TERM_CODE'.

my code:
SELECT a.*, c.*, d.* FROM " + Table1 + " a INNER JOIN " + Table3 + " c ON a.PO_NUMBER=c.PO_NUMBER INNER JOIN MGOCMGR_MGC_PAYMENT_TERM_MASTER d ON c.PO_PAYMENT_TERM_CODE=d.PAYMENT_TERM_CODE WHERE a.PR_STATUS='A' AND a.PR_NUMBER='0000000073'";

i'm using c# express and ms access 2000 database.

thanks.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories