Skip navigation links

MySQL Forums :: Newbie :: What's the difference between left outer join and left join??


Advanced Search

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?? g_p g_p 09/22/2010 04:29AM
Re: What's the difference between left outer join and left join?? laptop alias 09/22/2010 05:19AM
Re: What's the difference between left outer join and left join?? Gints Plivna 09/22/2010 06:44AM


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.