select
--Order Header Info
H.Inv_No, H.Ord_Type, H.Ord_No, Status, Bill_to_addr_1,Bill_to_addr_2,Bill_to_addr_3,Bill_to_addr_4, Ship_to_addr_1,Ship_to_addr_2,Ship_to_addr_3,Ship_to_addr_4
--Order Line Info
,l.Item_No,isnull(bdi.shortdescription,l.item_desc_1 + isnull(l.item_desc_2,'')) Description,l.qty_ordered ,l.qty_to_ship ,l.unit_price,l.discount_pct,l.sls_amt Sales
from oehdrhst_sql H (nolock)
join oelinhst_sql L (nolock) on h.ord_type=l.ord_type and h.ord_no=l.ord_no and h.inv_no=l.inv_no
left join BDItems25 BDI (nolock) on l.item_no = bdi.item_no
--Invoice # Range
--WHERE H.Inv_No >=1000 and H.Inv_No <=2000
--Invoice Date Range for January 2015
--WHERE H.Inv_Dt >=20150101 and H.Inv_Dt <=20150131