We have a products table that has a number of stock items relating to a number of customers. For reporting purposes, what I would like to do is to query all stock items relating to Customer code ‘0’, and show the price for that stock code for another (variable) customer for example customer 1002.
Each stock code should be on its own row, with customer 0 price in the first column, and customer 1002 price in the second column.
Stock codes for other customers should not be displayed. Customer 0 will always return a price. Customer 1002 may not alyways have a price.