If I use the following inner join of 3 tables: SELECT T1.A FROM (T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
SQLite returns an error message saying that the column T1.A does not exist. If I run this statement on MysQL, Oracle or DB2, they accept it. And in fact, this is correct SQL. If I remove the brackets, SQLite also accepts it. But sometimes you want to work with brackets, if you are combining inner and left outer joins. Any idea why this is not accepted by SQLite? Rick van der Lans ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
