Update - it ignores my cs.*, ir.* etc once I started defining every column so I have to define every column. There's probably more advanced method (beyond me at this point) to have 'For each column, add the suffix of the table name which comes after the dash(underscore)'. I only did the '_cs' at this point and below is what I have (it's working).
SELECT qr.quote_id_person,
cs.quote_id as cs_quote_id, cs.quote_id_person as cs_quote_id_person, cs.create_date as cs_create_date, cs.Product_Name as cs_Product_Name, cs.Specs_Name as cs_Specs_Name, cs.Machine as cs_Machine, cs.Material as cs_Material, cs.Thickness_Min as cs_Thickness_Min, cs.Thickness_Max as cs_Thickness_Max, cs.Core_Size as cs_Core_Size, cs.Max_Roll_Diameter as cs_Max_Roll_Diameter, cs.Width_Min as cs_Width_Min, cs.Width_Max as cs_Width_Max, cs.Web_Tension_Lbs_PLI_Min as cs_Web_Tension_Lbs_PLI_Min, cs.Web_Tension_Lbs_PLI_Max as cs_Web_Tension_Lbs_PLI_Max, cs.Machine_Speed as cs_Machine_Speed, cs.Max_Roll_Weight as cs_Max_Roll_Weight, cs.Application as cs_Application, cs.Core_Material as cs_Core_Material, cs.Thru_Shaft_Diameter as cs_Thru_Shaft_Diameter, cs.Notes as cs_Notes, cs.Upload_File_Name as cs_Upload_File_Name, cs.DateTime as cs_DateTime,
ir.quote_id_person AS ir_quote_id_person,
abr.*, ap.*, br.*, cma.*, cs.*, dra.*, ehr.*, fbr.*, fmr.*, frtrim.*, ir.*, isa.*, nra.*, rfq.*, rmb.*, rs.*, sct.*, sm.*, sr.*, ssc.*, ssh.*, str.*, sttrim.*, tc.*, us.*, ws.*
FROM quote_request AS qr
LEFT JOIN quote_request_abr AS abr ON
qr.quote_id_person = abr.quote_id_person
LEFT JOIN quote_request_ap AS ap ON
qr.quote_id_person = ap.quote_id_person
LEFT JOIN quote_request_br AS br ON
qr.quote_id_person = br.quote_id_person
LEFT JOIN quote_request_cma AS cma ON
qr.quote_id_person = cma.quote_id_person
LEFT JOIN quote_request_cs AS cs ON
qr.quote_id_person = cs.quote_id_person
LEFT JOIN quote_request_dra AS dra ON
qr.quote_id_person = dra.quote_id_person
LEFT JOIN quote_request_ehr AS ehr ON
qr.quote_id_person = ehr.quote_id_person
LEFT JOIN quote_request_fbr AS fbr ON
qr.quote_id_person = fbr.quote_id_person
LEFT JOIN quote_request_fmr AS fmr ON
qr.quote_id_person = fmr.quote_id_person
LEFT JOIN quote_request_frtrim AS frtrim ON
qr.quote_id_person = frtrim.quote_id_person
LEFT JOIN quote_request_ir AS ir ON
qr.quote_id_person = ir.quote_id_person
LEFT JOIN quote_request_isa AS isa ON
qr.quote_id_person = isa.quote_id_person
LEFT JOIN quote_request_nra AS nra ON
qr.quote_id_person = nra.quote_id_person
LEFT JOIN quote_request_rfq AS rfq ON
qr.quote_id_person = rfq.quote_id_person
LEFT JOIN quote_request_rmb AS rmb ON
qr.quote_id_person = rmb.quote_id_person
LEFT JOIN quote_request_rs AS rs ON
qr.quote_id_person = rs.quote_id_person
LEFT JOIN quote_request_sct AS sct ON
qr.quote_id_person = sct.quote_id_person
LEFT JOIN quote_request_sm AS sm ON
qr.quote_id_person = sm.quote_id_person
LEFT JOIN quote_request_sr AS sr ON
qr.quote_id_person = sr.quote_id_person
LEFT JOIN quote_request_ssc AS ssc ON
qr.quote_id_person = ssc.quote_id_person
LEFT JOIN quote_request_ssh AS ssh ON
qr.quote_id_person = ssh.quote_id_person
LEFT JOIN quote_request_str AS str ON
qr.quote_id_person = str.quote_id_person
LEFT JOIN quote_request_sttrim AS sttrim ON
qr.quote_id_person = sttrim.quote_id_person
LEFT JOIN quote_request_tc AS tc ON
qr.quote_id_person = tc.quote_id_person
LEFT JOIN quote_request_us AS us ON
qr.quote_id_person = us.quote_id_person
LEFT JOIN quote_request_ws AS ws ON
qr.quote_id_person = ws.quote_id_person
WHERE qr.quote_id_person = '" . $quoteid . "'");
