select Users.FirstName,Users.Email,br.*,Blogs.BlogTitle from BlogReplies br (NOLOCK) inner join Users on Users.UserID=br.UserID
where BlogID in
(
select BlogID from Blogs (NOLOCK) where UserID = '17059'
)
but this time i get new error =The multi-part identifier "Blogs.BlogTitle" could not be bound.
srinanthuram
Contributor
6800 Points
1549 Posts
Re: The column prefix 'br' does not match with a table name or alias name used in the query.
Feb 28, 2012 12:32 PM|LINK
k boss
i change my query
select Users.FirstName,Users.Email,br.*,Blogs.BlogTitle from BlogReplies br (NOLOCK) inner join Users on Users.UserID=br.UserID
where BlogID in
(
select BlogID from Blogs (NOLOCK) where UserID = '17059'
)
but this time i get new error =The multi-part identifier "Blogs.BlogTitle" could not be bound.
sry Do not know much sql....