In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...