时间戳

首页 > 解决方案 > 来自主表的mysql检查值中的子查询给出了未定义的错误

mysql - 来自主表的mysql检查值中的子查询给出了未定义的错误

问题描述

我的查询如下

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 的错误是 undefine

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

标签： mysql

解决方案

    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

尝试这个！:)

推荐阅读