select distinct table1.table1_id from table1,view1 where
view1.sex=0 and table1.name COLLATE Chinese_PRC_CI_AS =view1.name COLLATE Chinese_PRC_CI_AS select name from view1
where mobile COLLATE Chinese_PRC_CI_AS in (select DISTINCT mobile COLLATE Chinese_PRC_CI_AS from table2 where table2_id=100001
)
view1.sex=0 and table1.name COLLATE Chinese_PRC_CI_AS =view1.name COLLATE Chinese_PRC_CI_AS select name from view1
where mobile COLLATE Chinese_PRC_CI_AS in (select DISTINCT mobile COLLATE Chinese_PRC_CI_AS from table2 where table2_id=100001
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货