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 raise an error) Here is an example of results T1 and T2 (T1 and T2, as shown in the request before are result of subqueries) : T1 : id col1 col2 1 a b 2 c d 3 e f T2: id col3 col4 2 aa bb 3 cc dd 6 ee ff And i'd like to obtain the final resultset : id col1 col2 col3 col4 1 a b NULL NULL 2 c d aa bb 3 e f cc dd 6 NULL NULL ee ff Vincent Badier