Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Participant
1526 Points
238 Posts
Jan 06, 2012 09:45 PM|LINK
Try this:
var stories = db.Query("SELECT NewsArticle.NewsId, NewsArticle.NewsDate, NewsArticle.NewsTitle, NewsArticle.NewsText, " + "NewsArticle.NewsPictureUrl, NewsArticle.Newslink, " + "NewsArticle.IsVisible, UserProfile.Membername, UserProfile.Firstname, " + "UserProfile.Lastname, NewsCategory.CategoryName " + "FROM NewsArticle INNER JOIN UserProfile" + "ON UserProfile.UserId = NewsArticle.UserId INNER JOIN Newscategory" + "ON Newscategory.CategoryId = NewsArticle.CategoryId " + "WHERE NewsArticle.Isvisible = 1 " + "ORDER BY NewsArticle.Newsdate DESC");
Also check for typo errors... column name "Isvisible" = "IsVisible"?...
p3tar
Participant
1526 Points
238 Posts
Re: Please Help with Sql INNER JOIN
Jan 06, 2012 09:45 PM|LINK
Try this:
var stories = db.Query("SELECT NewsArticle.NewsId, NewsArticle.NewsDate, NewsArticle.NewsTitle, NewsArticle.NewsText, " + "NewsArticle.NewsPictureUrl, NewsArticle.Newslink, " + "NewsArticle.IsVisible, UserProfile.Membername, UserProfile.Firstname, " + "UserProfile.Lastname, NewsCategory.CategoryName " + "FROM NewsArticle INNER JOIN UserProfile" + "ON UserProfile.UserId = NewsArticle.UserId INNER JOIN Newscategory" + "ON Newscategory.CategoryId = NewsArticle.CategoryId " + "WHERE NewsArticle.Isvisible = 1 " + "ORDER BY NewsArticle.Newsdate DESC");If I helped please mark my posts as "Answer". Cheers.