<div>
Thank you very much<br />
<br />
It works great. It only took 0.5' on my PIII 866 machine.<br />
<br />
Best Regard<br />
<br />
Jerry
</div>


Thank you very much

It works great. It only took 0.5' on my PIII 866 machine.

Best Regard

Jerry

<div>
<div class="content wysiwyg-content">
I have to retrive records from a table that are not present in another table with the same schema. &nbsp;But I am working with access database and as much I know it doesn't support MINUS operator. &nbsp;I use following sql query instead.<br />
<br />
SELECT name FROM ref &nbsp;WHERE not exists (SELECT name FROM glossary WHERE ref.name=glossary.name)<br />
<br />
ref has 6571 records<br />
glossary has 11315 records<br />
<br />
It's extremely slow. &nbsp;It took about 2'48'' to return 124 records on a PIII 866 machine.<br />
<br />
Is there any other good way?<br />
<br />
Thanks in advance.<br />
<br />
Jerry
</div>
</div>


I have to retrive records from a table that are not present in another table with the same schema.  But I am working with access database and as much I know it doesn't support MINUS operator.  I use following sql query instead.

SELECT name FROM ref  WHERE not exists (SELECT name FROM glossary WHERE ref.name=glossary.name)

ref has 6571 records
glossary has 11315 records

It's extremely slow.  It took about 2'48'' to return 124 records on a PIII 866 machine.

Is there any other good way?

Thanks in advance.

Jerry

MINUS (set diff.) operator in Access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.