استخراج چند فیلد از چند جدول

[fahimi]

با استفاده از Common Table Expressions یا CTE می توان نیز انجام داد.

WITH Bedehi1 ( id, Bedehi)

AS

(SELECT  ID, Mablagh AS Bedehi11 FROM  Bedehi)

,Padakhti1 (ID,  Padakhti)

  AS

(SELECT   ID, Mablagh as Padakhti11  FROM Pardakhti )

,Dnshjoo1(id,name)

as

(select id,name from Daneshjoo)	

 select Dnshjoo1.ID,Dnshjoo1.name,Bedehi1.Bedehi ,Padakhti1.Padakhti

FROM     Bedehi1 INNER JOIN

           Padakhti1 ON Bedehi1.id = Padakhti1.ID

		   INNER JOIN Dnshjoo1 on Bedehi1.id = Dnshjoo1.ID