Options

Price List Query

Dave_beDave_be Member Posts: 35
edited 2010-04-05 in SQL General
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..

Comments

  • Options
    garakgarak Member Posts: 3,263
    How looks your SQL code:?: I think there is a simple error
    Do you make it right, it works too!
Sign In or Register to comment.