Question

sql server 如何创建2表关联的视图

然后要求一些属性列 怎么能创建？

Answer 1

Create view test1
select grpName from b where grpID=(SELECT a.grpID
FROM a INNER JOIN b ON c.usrID0 = a.usrID)