View Single Post
  #2 (permalink)  
Old February 10th, 2004, 10:33 AM
Greywacke Greywacke is offline
Authorized User
 
Join Date: Sep 2003
Location: Wonderboom South, Pretoria, Gauteng, South Africa.
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Greywacke
Default

oki i have worked in access 2002 (XP) with the query editor to return sortof what i want...

Code:
SELECT DISTINCT mmorpg.str_currency, mmorpg.str_name, servers.str_name, credits.lng_usercredits
FROM credits INNER JOIN (servers INNER JOIN mmorpg ON servers.lng_rpgid=mmorpg.lng_id) ON (credits.lng_rpgid=mmorpg.lng_id) AND (credits.lng_serverid=servers.lng_id)
WHERE credits.lng_userid=23 // this will be replaced later in asp with a session variable
ORDER BY mmorpg.str_name, servers.str_name
now the problem is that i need to return the field servers as one field, depicted as an array delimited by ", ".

i need to know asap is this possible and if so how do i go about joining it sothat i get only one record per MMORPG record, but with all the servers listed in that field?

if not, i will just have to come up with another plan...

Pierre
Reply With Quote