用存储过程啊
把你上面的语句写在里面就可以了
create procedure aa
as
SELECT *FROM 媒体名单 AS a WHERE id in(select top 1 id from 杭州报纸 where 单位地址=a.单位地址 order by id)执行
exec aa
把你上面的语句写在里面就可以了
create procedure aa
as
SELECT *FROM 媒体名单 AS a WHERE id in(select top 1 id from 杭州报纸 where 单位地址=a.单位地址 order by id)执行
exec aa
select a.* from 媒体名单 AS a left join 杭州报纸 b on a.单位地址=b.单位地址
select a.* from 媒体名单 AS a left join 杭州报纸 b on a.单位地址=b.单位地址 and a.id=b.id
(select top 1 id
from 杭州报纸 where 单位地址=a.单位地址
)