many-to-many into summary column

Question

I've got a db like this:

Accounts 
--------
id
BankName
AcctNumber
Balance

AccountGroups
-------------
id
GroupName

JoinAccountsGroups
------------------
aid
gid

I'm trying to generate data like this:

Bank       AcctNum       Balance    Groups
--------|--------------|----------|----------------
Citi       930938        400        Payroll
B of A     8372933       100        Monthly, Payroll
Wells      09837         800        -
Chase      8730923       250        Monthly

Is there an easy way of generating that Groups column in a sql query, that will combine the results of the join into a comma-separated field? I'm currently doing it on the php side using a secondary query on each row as I'm processing it. It's fine for a small dataset, but it seems pretty inefficient...

I'm using php > jet > ms access .mdb file.

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

This may help Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess

edited May 23 '17 at 11:48

Community

1
1

answered Feb 18 '09 at 16:10

Varun Mahajan

7,037
15
43
65

I'm not sure how that gets to be counted as a correct answer, since VBA functions can't be executed via ODBC or OLEDB. – David-W-Fenton Feb 19 '09 at 02:46

many-to-many into summary column

1 Answers1