-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: rsk_avcce
Message 3 in Discussion
1. Inner Join : Matching all the Columns from TableA and TableB 2.
Right Outer Join : All Columns from TableA along with matching Columns from
TableB 3. Leftt Outer Join : All Columns from TableB along with matching
Columns from TableA 4. Union Join : List all the Records from
TableA and TableB without any duplicates 5. Union All Join : List all
the Records from TableA and TableB with duplicates
This will First List the Records from TableA and and then from TableB
6. Cross Join : List NxM records; N-No of records in TableA;
M-No of records in TableB This situation will occur in
Inner Join if the Matching criteria in Where Clause is
not mentioned
7. Self Join : Self join is just like any other join, except that two
instances of the same table will be joined in the query. Check the attached
file for the examples. Sathish
View Attachment(s):
http://groups.msn.com/MumbaiUserGroup/_notifications.msnw?type=msg&mview=1&parent=1&item=19208
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
