<div>
Assuming you have a common ID field:<br />
<br />
SELECT Table2.*<br />
FROM table2 LEFT JOIN Table1 on Table2.ID = Table1.ID<br />
WHERE Table2.OpenForBusiness = true and Tabale1.ID IS Null
</div>


Assuming you have a common ID field:

SELECT Table2.*
FROM table2 LEFT JOIN Table1 on Table2.ID = Table1.ID
WHERE Table2.OpenForBusiness = true and Tabale1.ID IS Null

<div>
Thanks for your quick responses. That fixed it.
</div>


Thanks for your quick responses. That fixed it.

<div>
<div class="content wysiwyg-content">
I am trying to find all of the records in table 2 that do not exsist in Table 1 with some criteria like are open for business. I am using SQL 2000. 
</div>
</div>


I am trying to find all of the records in table 2 that do not exsist in Table 1 with some criteria like are open for business. I am using SQL 2000. 

SQL Outer Join Query Issue

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.