Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2008-11-18 : 20:57:32
|
| select top 25 agl.ArticleID, g.GroupID, g.Title as GroupName, a.Title as ArticleTitle, a.ArticleContent as ArticleContent, a.DateAdded-- into -- #TopArticles from groups g inner join (select articleID, max(groupid) as maxgroup from articlegrouplink group by articleid) agl on agl.maxgroup = g.groupid inner join articles a on a.articleid = agl.articleid inner join (select subscribid,max(groupid) as groupid from blogssubscriptiongroup by subscribid) b on b.groupid=ag1.maxgroupThe multi-part identifier "ag1.maxgroup" could not be bound.I am getting this error. how can i fix this. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-18 : 21:44:36
|
quote:
Originally posted by BendJoe
select top 25 agl.ArticleID, g.GroupID, g.Title as GroupName, a.Title as ArticleTitle, a.ArticleContent as ArticleContent, a.DateAdded-- into -- #TopArticles from groups g inner join (select articleID, max(groupid) as maxgroup from articlegrouplink group by articleid) agl on agl.maxgroup = g.groupid inner join articles a on a.articleid = agl.articleid inner join (select subscribid,max(groupid) as groupid from blogssubscriptiongroup by subscribid) b on b.groupid=agl.maxgroupThe multi-part identifier "ag1.maxgroup" could not be bound.I am getting this error. how can i fix this.
|
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-19 : 00:49:24
|
| Excellent Keen Observation sodeep.....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
The multi-part identifier could not be bound