Hi I'm using join Expression to select data from two tables , One for categories And the other for subcategories. But when i show the records each subcategory arrives next to category. Example: Category name(s) : Cars ,Announcements Sub categories name(s) For cars : Audi, Chevrolet, Geo Sub categories name(s) For Announcements : Announcements-General , New Business. When I show the records It looks like this: cars >> Audi cars >> Chevrolet cars >> Geo Announcements >> Announcements-General Announcements >> New Business ========== I need to show my records like this: cars >> Audi , Chevrolet , Geo Announcements >> Announcements-General , New Business ========== Commas are not important Note: I'm using ASP3 (classic) With VBscripts Language and My db is access
Please provide the table structure that you have.. Do you have two or three tables?? What is the relation with them?? Provide all related tables.. Isaac, http://www.7Live7.com