SQL1:
select A.THING_NAME,B.NQ_CYC,B.NQ_COUNT from lbxt_nq_criterion B,
LBXT_THING_NAME_INFO A
WHERE A.THING_NAME_ID=B.THING_NAME_ID(+) and B.WORK_TYPE_ID(+)=3SQL2:
select A.THING_NAME,B.NQ_CYC,B.NQ_COUNT from lbxt_nq_criterion B,
LBXT_THING_NAME_INFO A
WHERE A.THING_NAME_ID=B.THING_NAME_ID(+) and B.WORK_TYPE_ID=3
select A.THING_NAME,B.NQ_CYC,B.NQ_COUNT from lbxt_nq_criterion B,
LBXT_THING_NAME_INFO A
WHERE A.THING_NAME_ID=B.THING_NAME_ID(+) and B.WORK_TYPE_ID(+)=3SQL2:
select A.THING_NAME,B.NQ_CYC,B.NQ_COUNT from lbxt_nq_criterion B,
LBXT_THING_NAME_INFO A
WHERE A.THING_NAME_ID=B.THING_NAME_ID(+) and B.WORK_TYPE_ID=3
select A.THING_NAME,B.NQ_CYC,B.NQ_COUNT from lbxt_nq_criterion B,
LBXT_THING_NAME_INFO A
WHERE A.THING_NAME_ID=B.THING_NAME_ID and B.WORK_TYPE_ID=3
SQL1就是LBXT_THING_NAME_INFO a left join on (select * from lbxt_nq_criterion where WORK_TYPE_ID=3) b on a.THING_NAME_ID=B.THING_NAME_ID