https://www.webmaster-forums.net/crss/node/1037082 en https://www.webmaster-forums.net/serverside-scripting/sql-join-asp-using-record-sets#comment-1212981 <p>i fixed it i was being stupid really all i needed to do was </p> <p>select * from products where catagory ="&amp;ID</p> Wed, 03 Jan 2007 16:44:35 +0000 benf comment 1212981 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/sql-join-asp-using-record-sets#comment-1212943 <p>It seems like you are selecting two tables, obviously the recordset returned will be the result of merging the two tables.</p> <p>Does this code not work? The only things that seem wrong are [incode]catagories.Title as c[/incode] and [incode]products.Description as p[/incode]. I believe you need to remove the 'as c' and 'as p' parts as you repeat this later on with table instead of fields ([incode]from catagories c, products p[/incode]).</p> <p>If the code doesn't run, could you post what the error is? If you're just unsure of what to do with that recordset then let us know what you're trying to do and maybe we can point you in the right direction. <img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /></p> Wed, 03 Jan 2007 06:40:04 +0000 JeevesBond comment 1212943 at https://www.webmaster-forums.net