I have a database with Vendor, customer, product and sale tables.
Sales is related to product using product_NO. (upc)
Product_NO is used to identify Vendor_ID from vendor table.
Here I have two vendors with the same product_no in product table.
How can I figure a given sales of this product belong to which vendor?