Create SQL View from 2 tables
Posted on 2010-08-31
I have two tables in my database for simplicity sake they are as follows:
ITEM_NO, SEQ, COST and SKU, SEQ, COST the relationship is in the ITEM_NO/SKU field. the first table called MASTERMAIN has all of the items in a product database with a sequence ID of 1 the second table SEQTAB has all subsequent item senquences and their respective costs.
An Item in MASTERMAIN could be
and in SEQTAB
What I need to do is create a view as follows:
This cannot be that difficult but I am hitting a wall with it.
I am sure it will be painfully obvious when a solution is presented.
Any help would be grweatly appreciated.