SELECT u.ACcountsID, u.DisplayName, u.UserType, c.Phone
FROM (SELECT DisplayName, ACcountsID, ‘AppUser’ AS UserType
FROM dbo.MG_AppUser
UNION ALL
SELECT Doc_Name, ACcountsID, ‘DocUser’ AS UserType
FROM dbo.Doc_Users) AS u INNER JOIN
dbo.MG_CCounts AS c ON u.ACcountsID = c.ACcountsID
sql视图,一张主表与两张子表的关联 查询
最新推荐文章于 2023-10-05 21:50:24 发布