The LEFT join s is the key. The rest depends on your tables structire and result you want to get.

>
>I think I've got it:
>
>

>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_LineNum
>

>
>Got to do some testing to make sure it's correct, but so far it looks good.
>
>Thanks for your time.