Thanks Mike. I will consider your suggestions about putting all the data into one table. I did have a look at that database you mention and the layout was compelling.
However, if the querying would still cause me headaches I would be no further ahead. Behind in fact, because I've had to redesign the application to fit to the new db structure. btw tried your query adn still no luck. Server Msg: -3100, State: 42000, [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(A.id = S1.category_id) INNER JOIN auction_item_categories_sub2 S2 ON (S1.id = S2.category_id) INNER JOIN auction_item_categories_sub3 S3 ON (S2.id = S3.cateogyr_id) INNER JOIN auction_item_categories_sub4 S4 ON (S3.id = S4.category_id) INNER JOIN auc'. >> From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > >I forgot to change something when copy/pasting. > >SELECT > A.name >FROM > auction_item_categories A > INNER JOIN auction_item_categories_sub S1 > ON (A.id = S1.category_id) > INNER JOIN auction_item_categories_sub2 S2 > ON (S1.id = S2.category_id) > INNER JOIN auction_item_categories_sub3 S3 > ON (S2.id = S3.cateogyr_id) > INNER JOIN auction_item_categories_sub4 S4 > ON (S3.id = S4.category_id) > INNER JOIN auction_item_categories_sub5 S5 > ON (S4.id = S5.category_id) >WHERE > A.id = 1 > >Sorry about that.. > >Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
