Re: SQL subqueries and JOIN conditions

2006-09-06 Thread Philippe Poelvoorde
2006/9/4, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: Hello all, I need to perform an SQL statement over 5 different tables, with complex request. To do so, i'm using subqueries. SELECT ... FROM (SELECT .WHERE) as T1 LEFT JOIN (SELECT .WHERE) as T2 WHERE . The problem is that on

SQL subqueries and JOIN conditions

2006-09-04 Thread Vincent . Badier
Hello all, I need to perform an SQL statement over 5 different tables, with complex request. To do so, i'm using subqueries. SELECT ... FROM (SELECT .WHERE) as T1 LEFT JOIN (SELECT .WHERE) as T2 WHERE . The problem is that only JOIN seems working with subqueries (LEFT JOIN