Iran58
شنبه 16 مرداد 1389, 07:57 صبح
سلام
من كد زير را نوشته ام ودر ست عمل مي كند
alter proc Rang_tbl1
as
begin
select Rang ,COUNT(Rang)
from tbl1
group by Rang
endمشكل من اين است كهRangكليد خارج است وهنگاميكه مي خواهم jionكنم
باكد زير به پيام خطا زير برمي خورم
alter proc Rang_tbl1
as
begin
select tbl1.Id,tblRang.Name ,COUNT(Rang)
from tbl1
join tblRang on tbl1.Rang = tblRang.Id
group by Rang
end
Msg 8120, Level 16, State 1, Procedure Rang_tbl1, Line 4
Column 'tbl1.Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
من كد زير را نوشته ام ودر ست عمل مي كند
alter proc Rang_tbl1
as
begin
select Rang ,COUNT(Rang)
from tbl1
group by Rang
endمشكل من اين است كهRangكليد خارج است وهنگاميكه مي خواهم jionكنم
باكد زير به پيام خطا زير برمي خورم
alter proc Rang_tbl1
as
begin
select tbl1.Id,tblRang.Name ,COUNT(Rang)
from tbl1
join tblRang on tbl1.Rang = tblRang.Id
group by Rang
end
Msg 8120, Level 16, State 1, Procedure Rang_tbl1, Line 4
Column 'tbl1.Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.