MySQL Forums
Forum List  »  Newbie

What's the difference between left outer join and left join??
Posted by: g_p g_p
Date: September 22, 2010 04:29AM

Hello,

i'm studying left and right joins.
Now, i'm trying to study examples related to outer left join and outer right join.
1. is there any difference between outer left join and left join??

My left join works but i have a problem with full outer join:

mysql> select * from store s left outer join geography g on g.store_name = s.sto
re_name;
+-------------+-------+------+-------------+-------------+
| store_name | sales | date | region_name | store_name |
+-------------+-------+------+-------------+-------------+
| San Diego | $250 | 100 | West | San diego |
| boston | $700 | 100 | East | Boston |
| Los Angeles | $1500 | 100 | West | Los Angeles |
| Los Angeles | $300 | 100 | West | Los Angeles |
+-------------+-------+------+-------------+-------------+
4 rows in set (0.00 sec)

mysql> select * from store s full outer join geography g on g.store_name = s.sto
re_name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'full
outer join geography g on g.store_name = s.store_name' at line 1

2. The second query does not work, but why??

thanks, in advance



Edited 2 time(s). Last edit at 09/22/2010 04:54AM by g_p g_p.

Options: ReplyQuote


Subject
Written By
Posted
What's the difference between left outer join and left join??
September 22, 2010 04:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.