Adam, the code you gave didn't seem to work. same goes with Jochem. Although I think we are getting closer with the last bit of code Jochem posted.
Error: Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SQL: SELECT * FROM (((( auction_item_categories_sub5 AS s5 INNER JOIN auction_item_categories_sub4 AS s4 ON s5.category_id = s4.id ) INNER JOIN auction_item_categories_sub3 AS s3 ON s4.category_id = s3.id ) INNER JOIN auction_item_categories_sub2 AS s2 ON s3.category_id = s2.id ) INNER JOIN auction_item_categories_sub AS s ON s2.category_id = s.id ) INNER JOIN auction_item_categories AS c ON s.category_id = c.id WHERE auction_item_categories.id = 1 >Adam Howitt wrote: >> I'm not sure why you are using parenthesis for your joins since SQL >> doesn't need them. > >Access ... > > >> This may sound horribly simple but I noticed a >> change in your field naming convention throughout this thread. You have >> category_id for all your tables except for your alias s4 >> (auction_item_categories_sub4) where you have a field with an extra 'y' >> categoryy_id > >So that is one error, and the other one is the missing alias in >the predicate: >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.category_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 c.id = 1 > >Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190630 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