SELECT mi.inventory_item_id, mi.item_name, ibh.sdate1, ibh.sdate2, ibh.ebs_ins_qty FROM msd_dem_ins_base_history ibh, msc_items mi WHERE mi.item_name = ibh.level1
View Text - HTML Formatted
SELECT MI.INVENTORY_ITEM_ID , MI.ITEM_NAME , IBH.SDATE1 , IBH.SDATE2 , IBH.EBS_INS_QTY FROM MSD_DEM_INS_BASE_HISTORY IBH , MSC_ITEMS MI WHERE MI.ITEM_NAME = IBH.LEVEL1