<div>
Can you show the code you are using to get the data please..
</div>


Can you show the code you are using to get the data please..

<div>
SELECT<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DomainID,DomainName<br />
FROM tblDomainNames<br />
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)
</div>


SELECT
      DomainID,DomainName
FROM tblDomainNames
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)

<div>
There's no PHP, it's from interactive interface.<br />
i'll try with the other interface and see if it shows more detail.
</div>


There's no PHP, it's from interactive interface.
i'll try with the other interface and see if it shows more detail.

<div>
odd, it worked without error in the other interface!<br />
go figure - thanks for triggering me to do that
</div>


odd, it worked without error in the other interface!
go figure - thanks for triggering me to do that

<div>
Glad you are sorted, thanks for the points adn have a great New Year
</div>


Glad you are sorted, thanks for the points adn have a great New Year

<div>
<div class="content wysiwyg-content">
I get this error when executing:<br />
<br />
SELECT<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DomainID,DomainName<br />
FROM tblDomainNames<br />
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)<br />
<br />
<br />
there are only about 2000 records in each table
</div>
</div>


I get this error when executing:

SELECT
	DomainID,DomainName
FROM tblDomainNames
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)


there are only about 2000 records in each table

MySQL Resource ID #13

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.