-
Left Outer & Right Outer Join
What is the use of Left Outer & Right Outer Join, Using Equi Join with Union we can do the outer join then why we need to go for Outer Join
aytasirs
- Nov 15th, 2012
Left outer Join fetch all the records from Left side Table(Only Condition satisfied records from right side table) where as Right Outer Join fetch all the records from Right side Table(Only Condition satisfied records from Left side table).
sampra
- Mar 6th, 2012
Using Equi Join with Union we can do the outer join then why we need to go for Outer Join -- increase the performance
-
Retrieve data from two tables
How to retrieve data from two tables of different servers
Sujaya
- Jun 8th, 2012
SELECT Ename, DeptNo, Sal, Emp.DeptNo, Dept.Dname, Dept.Loc, Dept FROM
Emp, Dept
WHERE Emp.DeptNo = Dept.DeptNo;
