<div>
I found that this works:<br />
<br />
AND (Manager_Filter.`Unique` NOT IN (Select `Unique` from tblLock))
</div>


I found that this works:

AND (Manager_Filter.`Unique` NOT IN (Select `Unique` from tblLock))

<div>
<div class="content wysiwyg-content">
I have a table called Master, with a field in it called Unique.<br />
<br />
I have a separate table, called tblLock, also with a field called Unique (both varchar)<br />
<br />
I want a view of all the records in Master, UNLESS the unique fields match. &nbsp;So the tblLock table excludes records from Master.<br />
<br />
Thanks
</div>
</div>


I have a table called Master, with a field in it called Unique.

I have a separate table, called tblLock, also with a field called Unique (both varchar)

I want a view of all the records in Master, UNLESS the unique fields match.  So the tblLock table excludes records from Master.

Thanks

MySQL  - All from one table, not if in other

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.