Ruchi R

Ruchi R

  • NA
  • 112
  • 266.1k

Ambiguous column name 'btopicId'.

Feb 25 2010 2:41 AM
string MyQuery = "SELECT tblBlogTopic.btopicId, tblBlogTopic.btopicTitle, tblBlogTopic.btopicDescription, tblBlogComment.bCommentDescriptin, tblBlogComment.bcdatetime, tblBlogComment.Empid FROM tblBlogTopic INNER JOIN tblBlogComment ON tblBlogTopic.btopicId = tblBlogComment.btopicId where (btopicId='" + lstboxforblogtitle.SelectedValue + "')";

While running the above query, i am getting the following error.
" Ambiguous column name 'btopicId' "

Could anyone plz help me.

Answers (1)