From http://www.dbdebunk.com:



QUOTE OF THE WEEK

_____


Don't use joins ... Oracle and SQL Server have fundamentally different approaches to the concept ... You end up with unexpected result sets ... You should understand the basic types of join clauses ...

Equi-joins are formed by retrieving all the data from two separate sources and combining it into one, large table.

Inner joins are joined on the inner columns of two tables.

Outer joins are joined on the outer columns of two tables.

Left joins are joined on the left columns of two tables.

Right joins are joined on the right columns of two tables.

--Sanders Kaufman, Code for DBMS Independence, builder.com


MS Sql Server LazyDBA home page