<div>
I am doing a comparison<br />
This is what I am looing for<br />
<br />
If table1.field1 is equial to table2.field1 then if <br />
If table1field2 is not equal to table2.field2 feild show the records
</div>


I am doing a comparison
This is what I am looing for

If table1.field1 is equial to table2.field1 then if
If table1field2 is not equal to table2.field2 feild show the records

<div>
<div class="content wysiwyg-content">
I have an Acess 2003 table<br />
I hve a total of 10 fields. I want to tkae two fields and match them up to another table with the same fields - if one field matches and the second field does not &nbsp;- show that record in the query
</div>
</div>


I have an Acess 2003 table
I hve a total of 10 fields. I want to tkae two fields and match them up to another table with the same fields - if one field matches and the second field does not  - show that record in the query

Query to compare two fields - Access 2003

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.