两表关联查询，条件：在A表，A.“bm”去重的基础上，查询出A."ID",B."ZJ"相关字段得数据
select *
from
(select distinct bm from A) a inner join b on a.id=b.zj
select distinct A.BM,A.ID,B.ZJ FROM A,B
WHERE A.主键=B.主键
1min目标场景问卷
立即参与
