将表添加到现有查询

Question

我有一个表simsu_subs，它具有字段user_id和过期日期。 相同的字段名称user_id在另一个表mt_links中使用。

我有这样的查询工作完美：

SELECT link_published, 
    CASE link_published WHEN 1 THEN 'Published' ELSE 'No' END AS 'Published/no', 
    u.firstname, 
    u.lastname, 
    accreditations, 
    title_descriptor, 
    phone_number, 
    display_email, 
    u.website, 
    avatar, 
    logo, 
    disclaimer, 
    signature_ie_john_doe, 
    MAX(IF(lv.cf_id =24, lv.`value`, '')) AS `UploadGraphic`, 
    MAX(IF(lv.cf_id =36, lv.`value`, '')) AS `Color`, 
    MAX(IF(lv.cf_id =37, lv.`value`, '')) AS `BodyCopy`, 
    MAX(IF(lv.cf_id =39, lv.`value`, '')) AS `Salutation`, 
    l.link_name, 
    MAX(IF(lv.cf_id =38, lv.`value`, '')) AS `Magazine`, 
    address, 
    MAX(IF(lv.cf_id =35, lv.`value`, '')) AS `Address 2`, 
    city, 
    state, 
    postcode FROM cwpc_jsn_users u 
    INNER JOIN cwpc_mt_links l ON u.`id` = l.`user_id` 
    INNER JOIN cwpc_mt_cfvalues lv ON l.link_id = lv.link_id 
GROUP BY u.firstname, l.link_name 

这是我想添加查询：

SELECT b.expiry_date 
FROM cwpc_simsu_subs b 
JOIN cwpc_mt_links c 
ON b.user_id = c.user_id 

我想EXPIRY_DATE添加到该查询，通过USER_ID加入。我试图以更多的方式将字段和内部联接别名，而不是我所关心的。我只是无法让它工作。我在想

INNER JOIN cwpc_mt_links l ON u。 id = 1。 user_id

与它有什么关系？不完全确定。

有人能指出我正确的方向吗？

THX

Answer 1

别名l已经被使用，所以这可能是你的问题。我希望你的FROM条款看起来像：

FROM cwpc_jsn_users u 
    INNER JOIN cwpc_mt_links l ON u.`id` = l.`user_id` 
    INNER JOIN cwpc_mt_cfvalues lv ON l.link_id = lv.link_id 
    INNER JOIN cwpc_simsu_subs b ON b.user_id = u.id