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:16 PM|LINK
For start, there are missing commas
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 " + "ON UserProfile.UserId = Newsarticle.UserId INNER JOIN " + "ON Newscategory.CategoryId - Newsarticle.CategoryId " + "WHERE Newsarticle.Isvisible = 1 " + "ORDER BY Newsarticle.Newsdate DESC");
p3tar
Participant
1526 Points
238 Posts
Re: Please Help with Sql INNER JOIN
Jan 06, 2012 09:16 PM|LINK
For start, there are missing commas
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 " + "ON UserProfile.UserId = Newsarticle.UserId INNER JOIN " + "ON Newscategory.CategoryId - Newsarticle.CategoryId " + "WHERE Newsarticle.Isvisible = 1 " + "ORDER BY Newsarticle.Newsdate DESC");If I helped please mark my posts as "Answer". Cheers.