看看fitment.fit_province 的数据类型和sub_address.name是不是一样,是不是你要查:
Select fit_name,fit_province From fitment Where fit_name in (select [name] From sub_address)
Select fit_name,fit_province From fitment Where fit_name in (select [name] From sub_address)
Select fit_name,fit_province From fitment Where exists (select [name] from sub_address where [name] like '%fit_province%')
你加上[]有何用处???
================================================================
一件件的衣裳,一天天的游荡
一日日的向往,一个个的方向