Hassle-free live chat software re-imagined for business growth. 2 users, always free.
select r.id,r.consolidatedpronumber,r.PlantId,r.carrier, c.tocompany as ShipToCompany, c.toaddr1 as ShipToAdd1, c.tostate as ShipToState,c.tocity as ShipToCity,c.tozip as ShipToZipCode,c.conbolid as ConBol from consolidatedbolreports r join conbol c on r.consolidatedpronumber = c.conproid and r.Carrier=c.Carrier where consolidatedpronumber in (select conproid from conbol ) and r.consolidatedpronumber='123456' and r.PlantId='PLANT001' and r.carrier='Conway'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!