本文介绍了一个具体的SQL查询案例，展示了如何从多个表中联接数据并筛选特定条件下的记录。通过对B_BuildBaseInfo、A_agentCustoms等表的联接操作，实现了针对特定agent和客户的建筑信息查询。
SELECT
a.id,a.buildname,
b.recommendtime,
case WHEN(c.buildstatename = d.buildstatename) then 'true' else 'false' end state,
d.buildstatename,
b.agentid,
b.custid
FROM
B_BuildBaseInfo a
LEFT JOIN A_agentCustoms b ON a.id = b.buildid
LEFT JOIN B_BuildState c ON b.userstateid = c.id
left join B_BuildState d on b.buildid = d.buildid
WHERE
b.agentid = '40281b8154a30bda0154a30c49460001'
AND b.custid = '4028da3454e0814a0154e0814a7c0003';
a.id,a.buildname,
b.recommendtime,
case WHEN(c.buildstatename = d.buildstatename) then 'true' else 'false' end state,
d.buildstatename,
b.agentid,
b.custid
FROM
B_BuildBaseInfo a
LEFT JOIN A_agentCustoms b ON a.id = b.buildid
LEFT JOIN B_BuildState c ON b.userstateid = c.id
left join B_BuildState d on b.buildid = d.buildid
WHERE
b.agentid = '40281b8154a30bda0154a30c49460001'
AND b.custid = '4028da3454e0814a0154e0814a7c0003';
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
