SELECT md.number,sd.description from main_data md,sub_data sd

WHERE 1=1

AND md.vendor_id=sd.vendor_id(+)

AND md.inventory_id=sd.item_id(+)

Here i am using 2 tables main_data and sub_data, as for join rules we have to give n-1 join conditions, that...