SQL help needed please?

Question

Can some please explain how too write a join muliplte join and what the heck is the difference between and inner and outer join

Answer 1

Inner Join = Return only if both side has row
http://msdn2.microsoft.com/en-us/library/ms190014.aspx



Outer Join :
http://msdn2.microsoft.com/en-us/library/ms191472.aspx

Right Outer Join = Return All Rows Second Table and True condition from First Table

Left Outer Join =Return All Rows First Table and True condition from Second Table

Full Outer Join = Return All Row from First and second Table if either from First or second table is blank or null than that colomn will showing as blank or null

Answer 2

It does depend a bit on the dialect of SQL you are using...

http://www.techonthenet.com/sql/joins.php

I initially started making up some examples, but the above site explains it all, and it took me less time to find that than finishing my examples ;-)

Inner Join: Will return only the rows from the joined tables where the join condition is true for both tables.

Outer join: Will return all rows from the first table in the join, and only those rows from the second table where the join condition is true.

:-)