mysql - mysql 检查主表中的值的子查询给出了 undefined variable 的错误

Question

我的查询如下

SELECT
 * 
FROM`punit_master` `a`

LEFT JOIN 
(
    SELECT *
      FROM 
    (
        SELECT *
          FROM _map_contacts  as t
          LEFT JOIN  contact_master as c on c.contact_id = t.contact_id
          where t.punit_id =a.punit_id
        limit 1

    ) tm LEFT JOIN  contactdetail_master cd ON cd.contactdetail_id = tm.contactdetail_id
) b ON b.agreement_id = a.curr_tenant_agreement_id 

它给了我 a.punit_id is undefine 的错误

如何在子查询内的左连接中使用邮件表值

Answer 1

    SELECT
     * 
    FROM `punit_master` `a`
    LEFT JOIN 
    (
        SELECT *
        FROM 
        (
            SELECT *
                FROM _map_contacts  as t
                LEFT JOIN  contact_master as c 
                ON c.contact_id = t.contact_id
        ) tm 
        LEFT JOIN  contactdetail_master cd 
        ON cd.contactdetail_id = tm.contactdetail_id
    ) b 
    ON b.agreement_id = a.curr_tenant_agreement_id and a.punit_id = b.punit_id

试试这个! :)