Jochem. tried your code, but got the following error. Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
with this code you supplied. SELECT * FROM (((( auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE auction_item_categories.id = 1 >Protoculture Breetai wrote: > >SELECT id, category_id, name >FROM ((((auction_item_categories_sub5 s5 > INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id >= s4.id) > INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id >= s3.id) > INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id >= s2.id) > INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) > INNER JOIN auction_item_categories c ON s.category_id = c.id >WHERE auction_item_categories.id = 1 > >Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190619 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54