Thursday, October 15, 2009

Non-Equijoins



Retrieving Records with Non-Equijoins :
  • SELECT e.ename, e.sal, j.gra FROM emp e JOIN job_grd j ON e.sal BETWEEN j.lowest_sal AND j.highest_sal;
Outer Joins :

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Followers