Question

oracle SQL语句问题表A 表B region name name 重庆 a a............ ....

Answer 1

select t1.region, t2.name

from 表A t1 join 表B t2 on t1.name=t2.name

where t1.region='重庆