<div>
That looks correct. &nbsp;Are you using an older version of MySQL that doesn't support subqueries?<br />
<br />
You can fall back on...<br />
<br />
SELECT CLIENT, LOCIX, ACCT, STATUS<br />
FROM RMAST<br />
LEFT JOIN INWOSTAT ON (INWOSTAT.STATUS = RMAST.STATUS)<br />
WHERE CLIENT = 'XBA' AND INWOSTAT.STATUS IS NULL;<br />

</div>


That looks correct.  Are you using an older version of MySQL that doesn't support subqueries?

You can fall back on...

SELECT CLIENT, LOCIX, ACCT, STATUS
FROM RMAST
LEFT JOIN INWOSTAT ON (INWOSTAT.STATUS = RMAST.STATUS)
WHERE CLIENT = 'XBA' AND INWOSTAT.STATUS IS NULL;


<div>
Wow, not only did I misread the question, I then managed not to hit Submit 'til you already answered. &nbsp;Sorry about that!
</div>


Wow, not only did I misread the question, I then managed not to hit Submit 'til you already answered.  Sorry about that!

<div>
<div class="content wysiwyg-content">
I am trying to select records from one table if a field's contents are in another table. &nbsp;This is what I was thinking, although it did not work<br />
<br />
SELECT CLIENT,LOCIX,ACCT,STATUS, FROM RMAST WHERE STATUS IN (SELECT STATUS FROM INWOSTAT) AND CLIENT = 'XBA'<br />
<br />
Any ideas on how I would write this query to do what I am looking for?<br />

</div>
</div>


I am trying to select records from one table if a field's contents are in another table.  This is what I was thinking, although it did not work

SELECT CLIENT,LOCIX,ACCT,STATUS, FROM RMAST WHERE STATUS IN (SELECT STATUS FROM INWOSTAT) AND CLIENT = 'XBA'

Any ideas on how I would write this query to do what I am looking for?


Query Question

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.