Anyone know how to implement an INNER JOIN on an INNER JOIN with Inmagic's ODBC (and hey, while we're at it, how about an INNER JOIN on an INNER JOIN on an INNER JOIN)? Typically it's done something like the following:

SELECT Table1.AField, Table3.AField FROM Table1 INNER JOIN (Table2 INNER JOIN Table3 ON Table2.ForeignKey = Table3.PrimaryKey) ON Table1.PrimaryKey = Table2.ForeignKey WHERE Table2.AField = 'SomeValue'

Can't find any Inmagic ODBC documentation on this one apart from basic INNER JOIN/OUTER JOIN.

As well, another end goal is implementing an INNER JOIN between Table1.PrimaryKey and Table2.ForeignKey where Table2.ForeignKey is a repeating integer/number field (in order to deal with a many to many relationship). I believe it will work when the repeating field is of string data type, but it does not work if the repeating field is an integer (which it has to in this case because Table1.PrimaryKey is an Auto Number).

If the data structure is rationalized further, i.e. creating a junction table instead of relying on a repeating field, that would require an INNER JOIN on an INNER JOIN on an INNER JOIN.

Any help or hints would be much appreciated.

Ted