...AS TrailerUnit1, (select unit from equipment where load.Trailer2Key = equipment.equipkey) AS TrailerUnit2, route.rate, (route.rate*load.correctedvolume) AS RatedTotal, load.hourlyrate, (load.hourlyrate*load.addwork*load.hrlyhauls) as HourlyTotal, (HourlyTotal + RatedTotal) as HaulTotal FROM...