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 only JOIN seems working with subqueries (LEFT JOIN
raise an error)
What's the error you're getting ?
Here is an example of results T1 and T2 (T1 and T2, as shown in the
request before are result of subqueries) :
Have you try to use a view instead of subselect ?
--
http://www.myspace.com/sakuradrop : credit runs faster
http://www.w-fenec.org/ Rock Webzine
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
