Price List Query

Dave_be

I have a problem creating a report of a dynamic price list true SSRS.
I need the "Item" and "Sales price" tables.
From the "item" table I want to get the "unit price" for each record.
From the "sales price" table I need all the available prices for each item.

This should be my result set:

ITEM       UPrice      Sales Code    Price
AAA         1            NULL            NULL
AAA         1            EXPORT1      0.80
AAA         1            EXPORT2      0.75
BBB         10           NULL           NULL
BBB         10           EXPORT1      9.50
BBB         10           EXPORT2      9.30
...

A full outer join on the price list doesn't do the trick because it doesn't show the first line in the example above if a record in the "unit price" table exists..

garak

How looks your SQL code:?: I think there is a simple error