Multiple Data sources trying to determine lowest cost

[tdigiaco1]

I have a database that has 3-4 seperate catalogs of products from various distributors.
I am trying to determine across those 3-4 who has the lowest price on the item.
The key would be the manufacturer part number as that is the common denominator amongst them.
Any suggestions on how to do this?



Thanks!

[ssanfu]

Depends on the table structure. If you have a normalized structure, just do a query on the manufacturer part number and sort ascending or use "TOP 1" predicate.
If they are in separate tables, I would try a union query.