LegalAlien
Perch
A newbie to SQL - in desperate need of some help!
I have two tables: Categories and Products
I am trying to list all products, but instead of listing the Category ID (which is in the product table), I want to list the Category NAME (which is in the category table).
Here is my current SQL statement which is giving me a syntax error. Hopefully, you can see what I'm trying to do:
strSQL = "SELECT * FROM Products INNER JOIN ON products.CatID = Categories.ProdID "
I figure I just need to join the tables. Then I can pull fields from either table, right? ie:
<%=rs("catName")%>
Where am I going wrong?
I have two tables: Categories and Products
I am trying to list all products, but instead of listing the Category ID (which is in the product table), I want to list the Category NAME (which is in the category table).
Here is my current SQL statement which is giving me a syntax error. Hopefully, you can see what I'm trying to do:
strSQL = "SELECT * FROM Products INNER JOIN ON products.CatID = Categories.ProdID "
I figure I just need to join the tables. Then I can pull fields from either table, right? ie:
<%=rs("catName")%>
Where am I going wrong?