Since the beginning of learning SQL Server I'm pretty much confused with JOIN conditions that defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated key in the other table. Specifying a logical operator (for example, = or <>,) to be used in comparing values from the columns. Though going by BOL gives much a thought but still there needs to be a better...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/08/07/1301.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1301" width="1" height="1">