we have a table called transaction_details. when i write this query
SELECT DESCRIPTION, item, cust_code, pack_description, uos, pack, total_value, total_value_vat, total_value_goods, price_indicator from TRANSACTION_DETAILS where cust_code=1273 and item =371355 and item =371476 and item =371629 and item =370556 and item =370677 and item =370820 and item =370952 and item =371070 and item =371223 and item =372154 and item =372253 and item =371751 and item =371872
it shows me nothing in the result pane. we want to see the reult of these all the item one by one in single line of each item and dont want to be duplicate. thanks for helping.