如何使用CTE连接3个表？ [英] how to join 3 tables using CTE?

问题描述

我是sql sever 2008的新用户请看下面的链接，在下面这个链接只有两个表是加入我想要



再加入一个表是我想要展示的StdRclass Cloumn的StduentRegistartion。

看到

以下链接它清楚地谈话已经完成了plz帮我紧急任何一个感谢提前



如何在使用内连接时解决数据重复问题？ [ ^ ]

解决方案

S

  SELECT  SR.stdRClass，SD.stdDname，SD.stdDMarks，SA.dist，SA.Aera 
  FROM  studentregistration SR 
  INNER   JOIN  studentDetails SD  ON  SR.stdRid = SD.stdDid 
  INNER   JOIN  studentAdress SA  ON  SD.stdDid = SA.stdAid 
 其中​​ SR.stdRid = '  1' 和 SD.stdRid = '  1' 和 SR.stdRid = '  1' 
  group   by  SR.stdRClass，SD.stdDname，SD.stdDMarks，SA.dist，SA.Aera; 

hi i am new to sql sever 2008 pls see this below link in this below link only two table are join i want t

to join one more table that is StduentRegistartion from that StdRclass Cloumn i want to display.
see
the below link it clearly conversation has done plz help me urgent any one thanks advance

how to slove data duplication when using inner join?[^]

解决方案

S

SELECT SR.stdRClass , SD.stdDname , SD.stdDMarks , SA.dist, SA.Aera
FROM studentregistration SR
INNER JOIN studentDetails SD ON SR.stdRid = SD.stdDid
INNER JOIN studentAdress SA ON  SD.stdDid = SA.stdAid
where SR.stdRid='1' and SD.stdRid='1' and SR.stdRid='1'
group by SR.stdRClass ,SD.stdDname ,SD.stdDMarks ,SA.dist, SA.Aera;

这篇关于如何使用CTE连接3个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！