SELECT G.GENERIC_ITEM , O.CUST_NO , I.ITEM_NO , G.DELETE_MARK FROM OP_GNRC_ITM G, OP_CUST_MST O, IC_ITEM_MST I WHERE G.CUST_ID = O.CUST_ID AND G.ITEM_ID = I.ITEM_ID AND G.GENERIC_ID <> 0
View Text - HTML Formatted
SELECT G.GENERIC_ITEM , O.CUST_NO , I.ITEM_NO , G.DELETE_MARK FROM OP_GNRC_ITM G , OP_CUST_MST O , IC_ITEM_MST I WHERE G.CUST_ID = O.CUST_ID AND G.ITEM_ID = I.ITEM_ID AND G.GENERIC_ID <> 0