<div>
If your compound key is 'unique' you can just use 'INSERT IGNORE':<br />
<br />

<pre><code id="code-20-35365797-1">INSERT IGNORE INTO tblPrices (SupplierID, ProductCode) VALUES ....</code></pre>
</div>


If your compound key is 'unique' you can just use 'INSERT IGNORE':



INSERT IGNORE INTO tblPrices (SupplierID, ProductCode) VALUES ....

<div>
Thanks Angel with 4 l's!<br />
<br />
Just perfect!
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
Struggling with my SQL again,<br />
<br />
I am loading new data into tblPrices from tblPasteForLoad<br />
<br />
The tblPrices table has a compound key consisting of &nbsp; SupplierID and ProductCode.<br />
<br />
INSERT INTO tblPrices (SupplierID, ProductCode)<br />
SELECT SupplierID,ProductCode from tblPasteForLoad<br />
WHERE<br />
tblPasteForLoad.SupplierID<wbr /> <b>&amp; </b>tblPasteForLoad.ProductCod<wbr />e<br />
NOT EXISTS IN tblPrices<br />
<br />
Hopefully the above 5 lines of pseudo SQL will indicate the SQL I actually require.<br />
<br />
Thankyou!<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>
</div>


Hi,
Struggling with my SQL again,

I am loading new data into tblPrices from tblPasteForLoad

The tblPrices table has a compound key consisting of   SupplierID and ProductCode.

INSERT INTO tblPrices (SupplierID, ProductCode)
SELECT SupplierID,ProductCode from tblPasteForLoad
WHERE
tblPasteForLoad.SupplierID & tblPasteForLoad.ProductCode
NOT EXISTS IN tblPrices

Hopefully the above 5 lines of pseudo SQL will indicate the SQL I actually require.

Thankyou!











SQL - Insert Where Not Already Exists

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.