Hello,
I am working through a sql tutorial, and would like to perform this (written for 
oracle) outer join using mysql.

SELECT A1.store_name, SUM(A2.Sales) SALES 
FROM Georgraphy A1, Store_Information A2 
WHERE A1.store_name = A2.store_name (+) 
GROUP BY A1.store_name 


I am reading the docs, but do not understand. Could someone please give me a hand with 
this?

Thanks,
Scott Purcell




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to