Posted by laurenq uantrell on 11/18/05 01:09

Currently I'm using a UDF and a physical temp table to accomplish this
and I want to know if there's any way of doing it in a query or
subquery instead...

In TableA there are a bunch of rows:

InvitationID (PK) PartyID Partygoer
1 1 Jim
2 20 Bob
3 2 Frank
4 1 Robert
5 1 Pete

In TableB are rows:
PartyID (PK) PartyDate PartyName
1 1/1/2000 WildParty
2 1/1/2000 BoringParty

When a user runs a query to search for all parties on 1/1/2000 I want
the result to look like:

PartyID PartyDate PartyName Partygoer
1 1/1/2000 WildParty Jim, Robert, Pete
2 1/1/2000 BoringParty Frank


I'm hoping there's a solution to this.
Thanks,
lq

[Back to original message]