SELECT rfq.*, ; rfqdetail.rqd_desc, rqd_Linenum, rqd_needby, rqd_reqnum, rqd_qty,; quotes.quo_freight, quo_portother, quo_date, quo_daysvalid,; quotedetails.qud_delivery, qud_unitcost, ; Suppliers.sup_name, sup_pk; FROM rfq INNER JOIN rfqdetail ON rfq_pk = rqd_rfqfk; INNER JOIN rfqsuppliers ON rfq_pk = rqs_rfqfk; LEFT JOIN Suppliers ON rqs_suppfk = sup_pk; LEFT JOIN quotes ON rfq_pk = quo_rfqfk AND quo_suppfk = rqs_suppfk; LEFT JOIN quotedetails ON rqd_pk = qud_rqdfk AND quo_pk = qud_quotefk; ORDER BY sup_Name, rqd_LineNumGot to do some testing to make sure it's correct, but so far it looks good.