SQL多表查询

最新推荐文章于 2024-09-27 17:45:59 发布

Devil丶童话

最新推荐文章于 2024-09-27 17:45:59 发布

阅读量432

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/weixin_41281138/article/details/94614547

版权

SQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

四表联表查询，以T_VOS_Quality_Matching表为主表，且和T_VOS_Model_Matching,T_VOS_Region_Matching表为一对多关系，和T_VOS表为多对一关系，因为一对多关系，所以只能取Index最小的值

SELECT
t.ID,
T_VOS.UID,
t.ChineseName,
t.LargeClass,
(SELECT top 1 Name from T_VOS_Model_Matching WHERE UID = t.UID ORDER BY [Index] ) as ModelName,
(SELECT top 1 Brand from T_VOS_Model_Matching WHERE UID = t.UID ORDER BY [Index] ) as Brand,
(SELECT top 1 Name from T_VOS_Region_Matching WHERE UID = t.UID ORDER BY [Index] ) as RegionName,
(SELECT top 1 Province from T_VOS_Region_Matching WHERE UID = t.UID ORDER BY [Index] ) as Province,
T_VOS.Title,
T_VOS.Message
FROM T_VOS_Quality_Matching t,T_VOS
where T_VOS.UID = t.UID ORDER BY t.ID DESC