select b.businessname,a.address1, isnull(a.address2,'') as address2,a.city,sta.stateabbr, a.postalcode,co.countryname,c.firstname + c.lastname,e.emailaddress,p.areacode,p.phonenumber,so.supplyorderid,so.orderdate,s.supplyid,st.shippingtypedesc,sod.quantity,sod.price
from business b
inner join supplyorder so on b.businessid = so.businessid and so.deletedate is null
inner join address a on so.addressid = a.addressid and a.deletedate is null
inner join state sta on a.stateid = sta.stateid 
inner join supplyorderdetail sod on so.supplyorderid = sod.supplyorderid and sod.deletedate is null 
inner join shippingtype st on so.shippingtypeid = st.shippingtypeid and st.deletedate is null
inner join supply s on sod.supplyid = s.supplyid and s.deletedate is null
inner join contact c on c.contactid = (select max(c1.contactid) from contact c1 where c1.businessid = b.businessid) 
inner join email e on c.contactid = e.contactid 
inner join phone p on c.contactid = p.contactid
inner join country co on sta.countryid = co.countryid