sql两个表联合查询,删除重复值

2025-03-23 19:34:26
推荐回答(2个)
回答1:

select * from
(select distinct id from a)a,b
where a.id=b.id

回答2:

直接用distinct