Hi, I'm totally new at this so have no idea whether I'm asking for something easy or quite difficult.
I am working in MySQL 3.23.58/PHP and am trying to construct a rather complex query. I have three tables: resources (containing resid, descr, title, url), topicdir (containing topicid, resid) and topic (containing topicid, topic, parentid). Each resource is associated with numerous topics. Initially I wanted to get just all the resources associated with a particular topic (in this example #36), so had the following SQL statement: SELECT resources.title, resources.descr, resources.url FROM resources, topic_dir WHERE topic_dir.topic_id = 36 AND topic_dir.res_id = resources.res_id ORDER BY resources.title Now it gets a bit more complicated: I need all resources associated with topic 36 (or whatever) but also all topics with parentid 998 associated with the resources associated with topic 36. Because I'm working in an earlier version of MySQL, I can't use a subquery. Any ideas/solutions/help would be most appreciated! Many thanks, Emily -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
