"Chris White" <nothanks.com> wrote in message
news:OlIYMx4cEHA.1000@TK2MSFTNGP12.phx.gbl...
> I need help with a query.
> Here are my tables:
> [ServiceCategory]
> [ServiceCatID] [int] IDENTITY (1, 1) NOT NULL (PRIMARY KEY)
> [ServiceCategory] [char] (50) NULL ,
>
> [Services]
> [ServiceID] [int] IDENTITY (1, 1) NOT NULL (PRIMARY KEY)
> [ServiceCatID] [int] NULL ,
> [ServiceName] [char] (100) NULL ,
> [ServicePrice] [money] NULL ,
>
> [ServiceDetails]
> [ServiceDetailID] [int] IDENTITY (1, 1) NOT NULL (PRIMARY KEY)
> [Detail] [char] (50) NULL ,
>
> [ServiceDetailJoin]
> [ServiceID] [int] NOT NULL (PRIMARY KEY)
> [ServiceDetailID] [int] NOT NULL (PRIMARY KEY)
>
> Services(or Service Plans) and Service Details are Many to Many, different
> Services(Service Plans) can have different combinations of Service
Details.
> ServiceDetailJoin in the junction table to handle these combos.
> Not all Services have Service Details, I want a list of All ServiceName
and
> either Detail or Blank Line
>
>