php - 无效查询 : Not unique table/alias: 'st'

Question

您能帮我解决我的疑问吗？我检查了之前的查询表，它可以工作，但这个不行。

                SELECT cj.customer_jd,
                customertable.name,
                customertable.ordersize,
                cj.job_no,
                cj.id,
                cj.ordered_quantity, 
                cj.ordered_quantity,st.id AS sandingID,
                st.*
                FROM sandingtable AS st
                LEFT JOIN customer_job  AS cj  ON 
                customertable.id=cj.customer_jd
                RIGHT JOIN  st ON cj.id = st.`job_id`
               WHERE st.date= '$date' AND st.shift = '$shift' AND 
                st.sandingno=".$row['sandingno']."");

Answer 1

您尚未在 from 子句中定义 customer_table:

FROM sandingtable st LEFT JOIN
     customer_job cj 
     ON customertable.id = cj.customer_jd RIGHT JOIN
     st
     ON cj.id = st.`job_id`
WHERE st.date = '$date' AND st.shift = '$shift' AND 
      st.sandingno = ".$row['sandingno']."");

我不确定如何修复它，但也许是这样的:

from st left join
     customer_job cj 
     on cj.id = st.job_id left join
     customertable 
     on customertable.id = cj.customer_jd
. . .

注释:

• 我将使用 customertable 的别名 ct，但查询的其余部分使用 customertable。
• 您应该在查询中一致地使用左联接。混合左连接和右连接只会令人困惑。