select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=1有2403条记录select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=2只有1条记录..select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=1 or tjcs=2
有24000多条记录...
请教为什么会这样?
有24000多条记录...
请教为什么会这样?
3条SQL分别是:select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=1
select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=2
select * from tj_tjjlb WHERE TJBH in (select tjbh from tj_tjdjb where tjbh in (select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND tjcs=1 or tjcs=2
in (select tjbh from tj_tjdjb where tjbh in
(select tjbh from tj_tjdjb where dwbh like '0141%') and tjbh<='122140') AND TJXMBH ='0301' AND (tjcs=1 or tjcs=2))有24000多条记录...
请教为什么会这样?