|
|
Posted by Mintyman on 11/13/06 14:43
Hi,
I know some SQL but not enough to write the query i'm trying to create and
could do with some help!
I have 2 tables (Product and ProductProgram) that are linked by a common
identified 'ProductID'. Each product has 5 different price levels
(1,2,3,4,5) and these are stored in the ProductProgram table.
The ProductProgram table contains the following columns:
ProductID
Level
Price
The Product table has the following columns:
ProductID
Name
Description
Can anyone show me how to return each product with all 5 of their individual
price levels?
Navigation:
[Reply to this message]
|