how to join multiple tables using stored procedure

Question

Hi this is my tables structure :

and this is my stored procedure :

GO
ALTER PROCEDURE [dbo].[uspGetVote](@TeamID INT,@CardID INT)

AS

BEGIN

select cast(avg(VoteValue) as float) as [AverageVoteValue] from Vote where datediff(day,getdate(),LastModifiedDateTime) <= 7 and TeamID = @TeamID and CardID=@CardID Group By TeamID,CardID order by AverageVoteValue

END

i want to join VoteComment Table also please give me a query for that

thank you

Sivakumar · Answer

i am getting all average values with comments when i pass teamId and cardId

Sivakumar · Answer

When i execute this procedure get a error like this : Msg 8120 Level 16 State 1 Procedure uspGetVote Line 8 Column 'VoteComment.Comment' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. this is a procedure : GO ALTER PROCEDURE [dbo].[uspGetVote](@TeamID INT@CardID INT) AS BEGIN select Commentcast(avg(VoteValue) as decimal(82))as [AverageVoteValue] Comment from Vote inner join VoteComment on Vote.VoteId=VoteComment.VoteId where datediff(daygetdate()LastModifiedDateTime) and TeamID = @TeamID and CardID=@CardID Group By TeamIDCardID order by AverageVoteValue END

Upendra Pratap Shahi · Answer

select cast ( avg ( VoteValue ) as float ) as [AverageVoteValue] from Vote inner join VoteComment on Vote . VoteId = VoteComment . VoteId where datediff ( day  getdate () LastModifiedDateTime ) 7 and TeamID = @TeamID and CardID = @CardID Group By TeamID  CardID order by AverageVoteValue