سلام به همه ...
با این پروسیجر میشه هر چند تا جدول رو با هم join کرد :
USE [AnbarDB]
GO
/****** Object: StoredProcedure [dbo].[Kardex] Script Date: 03/10/2015 23:06:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[Kardex]
@Kala nvarchar(50)
AS
BEGIN
With T1(Kala, tedadkala, andaz, kalakol)
AS
(SELECT Kala, Count(Kala), SUM(Andaze), SUM(Kol)
from TBuy GROUP BY Kala),
T2(Kala, tedadkala2, andaz2, kalakol2)
AS
(SELECT Kala, Count(Kala), SUM(Andaze), SUM(Kol)
from TSel GROUP BY Kala)
select
dbo.TAnbar.Anbar as anbar,
dbo.TAnbar.Kalatype as noekala,
dbo.TKala.Cod as cod,
dbo.TKala.Kala as kala,
dbo.TKala.Vahed as vahed,
dbo.TKala.Toz as tozi,
dbo.TKala.Mojodi as mojodi,
dbo.TKala.Pic as pict,
tedadkala,
andaz,
kalakol,
tedadkala2,
andaz2,
kalakol2
From dbo.TAnbar
inner join dbo.TKala on dbo.TAnbar.Anbar = dbo.TKala.Anbar
inner join T1 on T1.Kala = TKala.Kala
inner join T2 on TKala.Kala = T2.Kala
where dbo.TKala.Kala = @kala
END
یا علی !