SELECT ttsysDict.dict_id as '镇区',count(projectmain.townid)as '个数'
from ttsysdict,projectmain
where ttsysdict.dict_id*=projectmain.townid
projectmain.recdate between 日期1 and 日期2
group by projectmain.townid,ttsysdict.dict_id
from ttsysdict,projectmain
where ttsysdict.dict_id*=projectmain.townid
projectmain.recdate between 日期1 and 日期2
group by projectmain.townid,ttsysdict.dict_id
SELECT ttsysDict.dict_id as '镇区',count(projectmain.townid)as '个数'
from ttsysdict,projectmain
where ttsysdict.dict_id*=projectmain.townid and
projectmain.recdate between 日期1 and 日期2
group by projectmain.townid,ttsysdict.dict_id
from ttsysdict left join projectmain on ttsysdict.dict_id=projectmain.townid
and projectmain.recdate between 日期1 and 日期2
group by projectmain.townid,ttsysdict.dict_id别听6哈乱说!哈,哈哈,哈哈哈......