表1如下:
对应表2的主键ID
现需查询出表一中的每条数据对应的两个region_name。解决办法如下:
SELECT
T2.EQ_NAME,
T1.ALARM_START_TIME,
T1.ALARM_LEVAL,
T1.ALARM_TYPE,
T1.RULE_DESC,
T1.FACTORY_ID,
T1.BUSSINESS_ID,
t3.region_name as factory_name,
t4.region_name as bussiness_name
FROM
MJ_EQ_ALARM t1
LEFT JOIN MA_EQ t2 ON T1.EQ_ID = T2.EQ_NO
LEFT JOIN MA_AREA t3 ON T1.FACTORY_ID = t3. ID
LEFT JOIN MA_AREA t4 ON T1.bussiness_id = t4.id
WHERE
T1.DEL_STATUS = 1