DATA WAREHOUSE - Oracle

Hi,

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?

Thanks
shmzAsked:
Who is Participating?
 
Gerwin Jansen, EE MVEConnect With a Mentor Topic Advisor Commented:
Unless you have VENDOR in the sales table as well, you cannot because product_no's are the same.
0
 
joinaunionCommented:
Are you able to create your own upc stickers?
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
I go with the previous post we need the vendor info in the sales table.  Also the info what you have provide is not sufficent can you provide some more details like each table descriptions.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
joinaunionCommented:
Gerwin were you answering my question?
You can create your own stickers with whatever discription you want.
We have it done at our workplace all the time.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
@joinaunion - No, I was answering the askers' question :)
0
 
shmzAuthor Commented:
Good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.