Posted by Ray on 09/10/07 02:17

The number of products will be determined by the "items" table. Here
is the query as I have it before any rotating and such. The select *
is for ease of use while in development.

select permutations.location_key, permutations.location_name,
permutations.item, permutations.Currency_Code, pp.price --
permutations.*, pp.*
from
(select * from item
cross join location) permutations
left join productPrice pp
on permutations.item_key = pp.item_key and
permutations.location_key = pp.location_key
order by permutations.location_key, permutations.Item_key

[Back to original message]