>This distributor wants a listing of locations to be delivered by day
>
>

>Sunday  Monday Tuesday   etc
>loc a       loc b       loc d
>loc j        loc k        etc           etc
>
>

>the table contains the daynumber Sunday =1, and the location,
>
>Can it be done in one query?

Naomi's answer is likely to suffice. But just curious, can you post the DDL for the table(s) involved?