These are my table structures . Could you please suggest me an
alternative:
tblArticles: ArticleID,Title,Summary,ContextSubTypeID,PostDate
tblArticlePages: ArticlePageID,ArticleID,PageNum,Content
tblAuthors:AuthorID, Name
tblArticleAuthors:ArticleID,AuthorID
tblContextSubtype:ContextSubTypeID,Name
I need to get Author,PostDate,Title,tblContextSubType.Name,PageN um,Content,
- these have to grouped accordingly by the respective fields. Content
need not be grouped by.