Query help - select 2 different prices from ITM1

Hi all,

I need some assistance with a query.

In a customized query, I need to show the item code and 2 different prices (price from price list 1 and price from price list 2). I am unsure how to do this because the where clause would be different for each price based on the pricelist #. I need to show the information for the item and prices in the same row.

Thanks for any help.

Jane