joining 3 tables (access database) - Programmers Heaven

Howdy, Stranger!

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

Categories

joining 3 tables (access database)

rayeldacxrayeldacx Posts: 1Member
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.