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