select dictionary0_.*
from SMP_RES_DICTITEMS dictionary0_, SMP_RES_DICTS dictionary1_
where dictionary0_.DICT_ID = dictionary1_.ID
and 1 = 1
and dictionary1_.DICT_GROUP = '0'
and dictionary1_.DICT_CODE = 'PROVINCE';
select *
from SMP_RES_DICTITEMS t1
join SMP_RES_DICTS t2
on t1.dict_id = t2.id
and t2.DICT_GROUP = '0'
and t2.DICT_CODE = 'PROVINCE';
from SMP_RES_DICTITEMS dictionary0_, SMP_RES_DICTS dictionary1_
where dictionary0_.DICT_ID = dictionary1_.ID
and 1 = 1
and dictionary1_.DICT_GROUP = '0'
and dictionary1_.DICT_CODE = 'PROVINCE';
select *
from SMP_RES_DICTITEMS t1
join SMP_RES_DICTS t2
on t1.dict_id = t2.id
and t2.DICT_GROUP = '0'
and t2.DICT_CODE = 'PROVINCE';
效率嘛,应该没什么差别吧