File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Left outer join
Joined: Oct 30, 2007
Aug 22, 2008 08:33:00
WHEN TO USE A LEFT OUTER JOIN?
Joined: Apr 14, 2004
Aug 22, 2008 08:39:00
Typically you would use this when you have a nullable foreign key or some other situation when you want stuff in the left table returned, regardless of whether there are any matching results on the right side of the join.
Don't get me started about those stupid
subject: Left outer join
left outer join Vs right outer join
How to use Left outer join in EJB 3.0
are these join same
SQL Join for two different columns
Joining 3 Tables
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014