Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is LEFT JOIN ?

user575089Jun 24 2011 — edited Jun 24 2011

I have gone through LEFT JOIN . Here is LEFT JOIN . Check the link

http://i218.photobucket.com/albums/cc298/curseofgoldendragon/test-3.png

I have a doubt here. I see we are picking all the records from Table A ...so, I dont think we need to join here.

We could just use a "select" query to fetch all the records from Table A...is not it ?

Hence, I dont find usefulness of "LEFT JOIN".

Can anybody explain if I'm missing something ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2011

Added on Jun 24 2011

#general-database-discussions

16 comments

205 views