SQL查询报错排查求助：多表关联INSERT排序仍存问题

Hey there! Let's break down why your SQL query is throwing errors—this looks like a straightforward issue with table aliases when joining the same table multiple times.

The Core Issue #

Looking at your code, you're joining the proses table three times but using the exact same alias p for all instances:

JOIN proses AS p ON sp.proses_1 = p.id_proses
JOIN proses AS p ON sp.proses_2 = p.id_proses
JOIN proses AS p ON sp.proses_3 = p.id_proses

Databases can't distinguish between identical aliases, so this is definitely causing a syntax error. On top of that, your SELECT clause has repeated p.name_proses entries, which would be ambiguous even if the joins worked.

Fixed Query Example #

Here's how to adjust your query with unique aliases for each proses join, plus clear column names to avoid confusion:

$whls = querywheels("SELECT c.pn_car, pc.pn_partcar, pc.name_partcar, 
    p1.name_proses AS proses_1_name, 
    p2.name_proses AS proses_2_name, 
    p3.name_proses AS proses_3_name, 
    tc.cost_total, sp.total_price, r.rate_year, sp.total_all 
FROM secondproses AS sp 
JOIN proses AS p1 ON sp.proses_1 = p1.id_proses 
JOIN proses AS p2 ON sp.proses_2 = p2.id_proses 
JOIN proses AS p3 ON sp.proses_3 = p3.id_proses
-- Don't forget to finish all remaining JOIN clauses (like joins to c, pc, tc, r tables) with proper conditions
");

Quick Additional Checks #

• Your original query cuts off mid-clause (JOIN proses AS p ON sp.proses_3 = p.id...)—make sure you complete all JOINs and include valid conditions for every table you're referencing (like c, pc, tc, r).
• If your INSERT logic still fails after fixing this query, verify that the number of columns returned by this SELECT matches the columns in your INSERT target table, and that data types line up correctly.

内容的提问来源于stack exchange，提问作者Ainal Yaqin