SQL - using LIKE to match two tables

Good afternoon,

I'm not sure if I am going about this in the correct way and I hope that someone can point me in the right direction.

I am looking for Duplicate products in our Stock database as sometimes codes get opened when there is already a code available.

For this exercise we have a stock code, description and three different supplier codes from three different suppliers. I created a table with Stock Code (FSWCODE) and all the rest merged into one (Search)

I'm just not sure if I have the syntax correct or if doing it this way is even the best way

My Idea is to list all the stock details from the original STStockDetails table and then search for each supplier code within the AGSup table and then return the matching Stock code.

Below is the syntax I am trying to use, but will not work.

Please Login or Register  to view this content.

If you're looking for duplicate supplier codes of a product number just do

Please Login or Register  to view this content.

If you're looking for duplicate supplier codes of a product number just do

Please Login or Register  to view this content.