close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Control panel that displays like Webassist Email block. - that joins a lot of tables (23 tables) based on an ID

Thread began 4/29/2019 11:25 am by lr_leal239405 | Last modified 5/14/2019 2:33 pm by lr_leal239405 | 129 views | 12 replies

lr_leal239405

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 . "'");

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...