Problem with inner join

[algroth]

Hi!

I try to do a nested inner join by sql, but I always get an
"Syntax-error in FROM-clause".

The statement I try around with is:

SELECT * FROM st1
INNER JOIN st2
INNER JOIN st3
ON st1.id_col=st2.id_col
ON st2.id_col=st3.id_col
;

In my real statement, there are some WHERE-clauses, I don't select *
and st1, st2 and st3 and aliases for the same table.

Can anybody give me a hint about what's wrong with this statement? I
already tried lots of different variants with brackets (found in the
JET-reference and in the web and AND's between the ON's but nothing
worked...

CU
Goodbyte

[Howard Brody]

I think the syntax is FROM table 1 JOIN table 2 ON joined fields JOIN
table 3 ON joined fields. Try:

SELECT ...
FROM st1
INNER JOIN st2
ON st1.id_col = st2.id_col
INNER JOIN st3
ON st1.id_col = st3.id_col

Hope this helps!

Howard Brody
al*****@gmx.de wrote:

Hi!

I try to do a nested inner join by sql, but I always get an
"Syntax-error in FROM-clause".

The statement I try around with is:

SELECT * FROM st1
INNER JOIN st2
INNER JOIN st3
ON st1.id_col=st2.id_col
ON st2.id_col=st3.id_col
;

In my real statement, there are some WHERE-clauses, I don't select *
and st1, st2 and st3 and aliases for the same table.

Can anybody give me a hint about what's wrong with this statement? I
already tried lots of different variants with brackets (found in the
JET-reference and in the web and AND's between the ON's but nothing
worked...

CU
Goodbyte

[algroth]

SELECT * FROM st1
INNER JOIN st2
ON st1.id_col = st2.id_col
INNER JOIN st3
ON st1.id_col = st3.id_col
;

leads to "Syntax error (missing operator) in query expression
"st1.id_col=st2.id_col INNER JOIN st3 ON st1.id_col=st3.id_col".
:-(

CU
Stefan

[algroth]

Isn't anybody out there, who can help me with this little query?

CU
Stefan

[algroth]

ok, I found it:
with st1 to st3:

SELECT * FROM (st1
INNER JOIN st2
ON st1.id_col = st2.id_col)
INNER JOIN st3
ON st1.id_col = st3.id_col
;

with st1 to st4:

SELECT * FROM ((st1
INNER JOIN st2
ON st1.id_col = st2.id_col)
INNER JOIN st3
ON st1.id_col = st3.id_col)
INNER JOIN st4
ON st1.id_col = st4.id_col
;

CU,
Stefan