Multiple joins

[toutski]

Hi,
I was wondering if it is possible to join more than two tables inside a query. Im getting an error and I assume it is becaue im trying to join multiple tables.

It works in SQL using:

'Select USERCARD.HOLDID, MASTPLU.LOYALTY_POINTS, CHIPTRAN.PLQTY from CHIPTRAN
inner join USERCARD on USERCARD.SERIALNO = CHIPTRAN.SERIALNO
inner join MASTPLU on CHIPTRAN.MASTLINE = MASTPLU.MASTLINE
inner join MAC on MAC.MACID = CHIPTRAN.MACID
where... '

Any ideas???

 

[Chris RR]

I don't know what my own record is for multiple joins within a query...but it's a lot more than two! What is the error you are getting.

 

[toutski]

The error is:

Syntax error (missing operator) in query expression 'USERCARD.SERIALNO = CHIPTRAN.SERIALNO
inner join MASTPLU on CHIPTRAN.MASTLINE = MASTPLU.MASTLINE
inner join MAC on MAC.MACID = CHIPTRAN.MACID
where...'

 

[Chris RR]

Can you post the SQL for your entire Access query?

 

[Pat Hartman]

Why not create the joins in QBE view and let Access generate the SQL rather than searching for the syntax error?