|Some understanding about joins||tawright915||9/21/06 1:52 PM|
Can someone please help me in understanding inner and outer joins? I
seem to have a block when it comes to understanding this concept.
And please if you have nothing helpful to contribute then please do not
|Re: Some understanding about joins||Charles Hooper||9/21/06 6:57 PM|
Assume that the following table and columns in those tables, and data
Inner join TABLE_2 and TABLE_3
(Left) Outer join TABLE_2 and TABLE_3, include all rows from TABLE_2
Inner join TABLE_1 and TABLE_2
(Right) Outer join TABLE_1 and TABLE_2, include all rows from TABLE_2
(One Method, Full) Outer join TABLE_1 and TABLE_2, include all rows
|Re: Some understanding about joins||tawright915||9/22/06 6:38 AM|
Thank you so much. The light went on.
|Re: Some understanding about joins||john....@newscale.com||9/26/06 9:31 PM|
There's a good discussion at http://en.wikipedia.org/wiki/Join_(SQL)
|Re: Some understanding about joins||Channesh||9/27/06 7:58 PM|
Beautifully put answer!
|Re: Some understanding about joins||siva||9/29/06 9:18 PM|
Thanks Charles Hooper,
its really a nice reply it helped me to get out of the confusion
thanking you once again