SELECT OPRN_NO , FROM_ITEM_CLASS , TO_ITEM_CLASS FROM CR_SQDS_TBL C, FM_OPRN_MST F WHERE C.OPRN_ID = F.OPRN_ID GROUP BY OPRN_NO, FROM_ITEM_CLASS, TO_ITEM_CLASS
View Text - HTML Formatted
SELECT OPRN_NO , FROM_ITEM_CLASS , TO_ITEM_CLASS FROM CR_SQDS_TBL C , FM_OPRN_MST F WHERE C.OPRN_ID = F.OPRN_ID GROUP BY OPRN_NO , FROM_ITEM_CLASS , TO_ITEM_CLASS