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.
Subject
Written By
Posted
What's the difference between left outer join and left join??
September 22, 2010 04:29AM
September 22, 2010 05:19AM
September 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.