Hi all, another question for you, any help appreciated!
I have 2 tables: record_overview (which is main data table) and TOC (table of contents)
in my catID field in record_overview i have 4 digit number that distinguish its category. In my TOC table i have the category description field ie
9999 - pop music
8898 - classical
etc
i want to show my records on page with the description field of my TOC table next to it. I know i have to join tables in the SQL query but i am having no luck. At the moment all i am getting is the 4 digit number instead of the full category description.
this problem has come to light from a results.asp page where i have no categoey id string to pass on ie my home page to category.asp passed category id in its url.
hope it makes sense and someone can help
thanks
mark
Topic Options
Post Options
Thanks(0)
