join按照功能大致分为三大类:
inner join 内连接或等值连接: 获取两个表中字段匹配关系的记录 可以忽略inner 直接写 join
left join 左连接: 获取左表所有记录,即使右表没有对应匹配的记录
right join 右连接: 获取右表所有记录,即使左表没有对应匹配的记录
1、数据
##
SELECT
*
FROM
meter_base
WHERE
meter_code = 561802830001
有值
1507877627800019229 197.900 2022-03-27 05:37:59 197.900 2022-03 2022-04 5.400 18730951146 56180283 01 2 1346661844794081403 561802830001 1346988564638323002 1006043662 陈志凯 1 2022-03-27 08:30:16 2022-03-27 08:30:16 1346353018555478114 80.紫晶悦城一区(清雅苑).桥西 12 永和街清雅苑小区6-2-2703 0 0 -1.300 0 1 1346365455950295122 19.00 1346352590442868826 1347074556379856985 0 0 192.500 5.400 1
SELECT
*
FROM
device_watermeter
WHERE
meter_code = 561802830001
无值
2、##left join
SELECT
mb.id,
dw.id
FROM
meter_base mb
LEFT JOIN device_watermeter dw ON mb.meter_id = dw.id
WHERE
mb.meter_code = 561802830001
有值
1507877627800019229
3、##rigth join
SELECT
mb.id,
dw.id
FROM
meter_base mb
RIGHT JOIN device_watermeter dw ON mb.meter_id = dw.id
WHERE
mb.meter_code = 561802830001
无值
3、##inner join
SELECT
mb.id,
dw.id
FROM
meter_base mb
INNER JOIN device_watermeter dw ON mb.meter_id = dw.id
WHERE
mb.meter_code = 561802830001
无值