Hi so currently I am using VS2008 and am using a DNN module to pull information based on a specific Article on our website. On the home page I am currently displaying the Title, Summary, Date and Author of the article. Currently under our feature Stories section of the site http://prepsonthenet.com/dnn/Home/tabid/386/Default.aspx the Title, Summary and Date, Author are being displayed for the top 8 articles that contain images. I was able to combine the 'Author' and Article table to display the 'AuthorName' for the first 8 images. That code is below:strQueryArticleFirst.Append("select top 4 ArticleID,Title,Summary,[Text],");strQueryArticleFirst.Append("(SELECT NAME FROM AUTHOR AU WHERE AU.AUTHORID = Article.AUTHORID) AS AUTHORNAME, ");strQueryArticleFirst.Append("Convert(varchar(50),date,110)as [Date] from article");strQueryArticleFirst.Append(" WHERE CategoryID=27 AND State='WI' AND deleted is null "); Within this we have a strQueryArticleSecond which displays the next 6 stories without images: http://prepsonthenet.com/dnn/Home/tabid/386/Default.aspxThe code is a bit different here though and I can't seem to figure out how to link this back up to grab the 'AuthorName' strQueryArticleSecond.Append("SELECT * FROM(");strQueryArticleSecond.Append("select top 4 * from( ");strQueryArticleSecond.Append("select top 8 * from article ");strQueryArticleSecond.Append("where CategoryID=27 AND State='WI' and deleted is null ");I get what the strQueryArticleSecond and how it is grabbing all the fields that were used in strQueryArticleFirst. I am just wondering how to re-link the AuthorName is this strQueryArticleSecond. Any help is appreciated. Thanks!
Query to pull data from 2 different tables
Posted - 2009-09-17 : 12:08:21
