You don't need two queries, only one ... you need to make use of a join to grab the data from the two tables. Something along the lines of this:
SELECT tableBrochures.intBrochureIDPK, tableBrochures.strTitle, tableBrochures.dtDateModified, tableCategory.strCategory, tableCategory.intSortOrder...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.