I need to see if i can create a singe query to give me the result set that i need, but can't get there. This is what i tried first, but could use any help someone is willing to offer.
Thanks

SELECT f.flt_no, f.flt_date, v.cargoLoad, x.HazMat, y.Human, z.Animal
FROM flt_log f
INNER JOIN
(SELECT sum(wt) as cargoLoad, flt_no
from awbtxns
where txns_type IN ('M','B')) as v
ON f.flt_no = v.flt_no

INNER JOIN
(select count(b.HAZ_MAT_YN) as HazMat, a.flt_no
from awbtxns a, awbrec b
where a.txns_type IN ('M','B')
AND b.HAZ_MAT_YN = 'Y'
AND a.airline = b.airline
AND a.awb_no = b.awb_no
AND a.freight_type = b.freight_type) as x
ON f.flt_no = x.flt_no

INNER JOIN
(select count(b.std_af) as Human, a.flt_no
from awbtxns a, awbrec b
where a.txns_type IN ('M','B')
AND b.std_af = 'H'
AND a.airline = b.airline
AND a.awb_no = b.awb_no
AND a.freight_type = b.freight_type) as y
ON f.flt_no = y.flt_no

INNER JOIN
(select count(b.std_af) as Animal, a.flt_no
from awbtxns a, awbrec b
where a.txns_type IN ('M','B')
AND b.std_af IN ('5','7','B','C','I','L','T','Y')
AND a.airline = b.airline
AND a.awb_no = b.awb_no
AND a.freight_type = b.freight_type) as z
ON f.flt_no = z.flt_no

WHERE f.flt_date = ('04-04-10')
AND f.xml_sent_yn = 'N';