SELECT MAIN_NAME FROM abs_mainjob b RIGHT JOIN
(SELECT MAIN_ID from abs_subjob s JOIN
(SELECT
SUB_JOBID
FROM
abs_relation
WHERE
USER_ID = 123
AND DEL_FLAG <> 0) a ON a.SUB_JOBID = s.SUB_ID ) k ON k.MAIN_ID=b.MAIN_ID GROUP BY b.MAIN_NAME 在mysql中执行这个sql可以查询到,在php中 查不到
查不到的话 会报什么东西
查询代码 贴出来看看