" /> Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
Home SQL Full Join
SQL Full Join
PDF

FULL JOIN 

1
2
3
4

SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON =table_name2.column_name

There is a table "Persons":

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15

For this we use this query:

1
2
3
4
5

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
FULL JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName

Query Result:

LastName FirstName OrderNo
Hansen Ola 22456
Hansen Ola 24562
Pettersen Kari 77895
Pettersen Kari 44678
Svendson Tove
34764

Comments

 
+3 #1 Andrew 2010-08-11 09:12 SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON =table_name2.column_name

- It's all clear! and if I do not have to choose from 2 tables, and of 3,4,5,6 ... the syntax, how to write from ...!? Quote
 
 
+1 #2 German 2010-10-12 11:43 Like this, I think INNER JOIN and FULL JOIN is not particularly use different syntax, I have worked at least
SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON 1=table_name2.column_name1
FULL JOIN table_name3
ON 2=table_name3.column_name2

in general 4 tables in one query and the call goes to different speakers and even a bunch of 2 and 3 of table type

FULL JOIN table_name2
ON table_name2.column_name=table_name3.column_name Quote
 
 
0 #3 max 2011-05-12 15:26 What's the fundamental difference between Cross Join? Quote
 
 
0 #4 MOPO3OB 2011-06-20 10:50
What's the fundamental difference between Cross Join?


Cross Join returns all possible combinations of each line on each. In this case, using the Cross Join, a query would return 15 rows = 3x5 Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Advertisement
© 2009 ageent.ru.