I am trying to query database tables setup w/ Many to Many Relasionship.

[tblBusiness] - [tblBusCats] - [tblCategories]

My goal is to return the fields in tblBusiness, and a field w/ Comma delimited list of Categories.

This will Return the comma delimited list of Categories for a single input.

I tried to combinw this with the select for Businesses using a subquery but I get the following errror:

Incorrect syntax near '='.

Here is the code:

DECLARE @CatList varchar(1000) SELECT b.BusinessID, b.BusNam ,StrAddr ,State,Zip,Phone ,Fax ,Email,ShrtDescr ,LongDescr,FrontPic, Map( SELECT @CatList = COALESCE(@CatList + ', ', '') + c.CatNam FROM tblBusiness b LEFT JOIN tblBusCats bc ON bc.BusinessID = b.BusinessID INNER JOIN tblCategories c ON c.CategoryID = bc.CategoryID WHERE b.BusinessID = bc.BusinessID SELECT @CatList ) FROM tblBusiness b

Could anyone give me a suggestion on how to resolve this?

Thanks