Sql needed for this logic

[aniletc37]

hi,



hi,
I have two tables like below,I need to check whether table1 data is matching with table2 data based on supplier.Here problem is
in table1 we have two suppliers ebay and amazon and it's ids are 1 and 2 for other suppliers it should be anything.In table2
for ebay and amazon and it's ids are 11 and 22.By using inner join i can match these data but for ebay and amazon id's are differnet
in table2.I need to check these two tables when in table1 ebay and amazon suppliers ids are 1 and 2 and in table2 ebay and amazon suppliers ids are 11 and 22
as per business logic and for remaining suppliers wat ever ids are present in table1 should match with table2 suppliers wat ever ids are present except ebay and amzon
.for ebay and amzon ids are 11 and 22.any one can help me on this querry.

table1:

Supplier	id	value
ebay	1	4
amazon	2	5
aa	3	6

table2:

Supplier	id	value
ebay	11	4
amazon	22	5
aa	3	6

[lfpm062010]

Base on your explaination, you are trying to match on the "ID" for both table.

Have you consider match on the "Supplier"? Are the names of supplier same for both table?

If you are still trying to match on the "ID", you can create a query that change the ebay from 1 to 11 and amazon from 2 to 22 and use that query to match the second table (Not recommended, but it will work).

[orange]

It is not clear from your description what the issue is. Are you having trouble with SQL or do you have a database design issue whereby the Suppliers are identified differently in different tables?
If the latter, then you can see why having a unique identifier for Suppliers is important across an organization.