TABLE A ;TABLE B
内连接:A INNER JOIN B ,在A中也有,在B中也有的数据才能查询出来
左连接:A LEFT JOIN B,连接查询的数据,在A中必须有,在B中可以有可以没有
右连接与左连接相反
左连接查询的两种查法
-- 链接查询,后再过滤
SELECT uw.ITEM_USER_ID,uw.ITEM_WORK_ID,wm.* from tlk_uid_wid as uw
LEFT JOIN tlk_workrecordmonth as wm on uw.ITEM_WORK_ID = wm.ITEM_WORK_ID
where uw.ITEM_USER_ID="11e6-1ca7-fa6a5f88-9915-490ea07f921f";
-- 过滤后,在链接查询
SELECT uw.ITEM_USER_ID,uw.ITEM_WORK_ID,wm.* from
(select * from tlk_uid_wid where ITEM_USER_ID="11e6-1ca7-fa6a5f88-9915-490ea07f921f") as uw
LEFT JOIN tlk_workrecordmonth as wm on uw.ITEM_WORK_ID = wm.ITEM_WORK_ID;