sql server 视图重复列问题

表A 列 Series ID Content
表B 列 Series QSeries text

表B中QSeries对应 表A 中Series

创建一个视图，视图中 显示 Series ID Content QSeries text

要求表A中一个Series 只对应 表B中一条数据

 SELECT A.*,(SELECT top 1 * FROM B WHERE QSeries=Series) AS QSeries  FROM A

select * from a left join
(select max(QSeries) as QSeries,test from b group by text) c
on a.Series ID=c.QSeries