Hi! Thanks for checking out my dilemma!
I know I have done this before (in another db) but I can't recall exactly.
What I have are two sources: a query of open invoices that creates a customer statement and a table of customer contacts.
When I export to excel, I want to take the contacts with me - but I do not want to duplicate my invoice records for all the contacts.
The query fields(invoice) are ID, ACCT, INVNO,INVDATE, INVAMT, AGE, DUE
The table fields(contact) are CID, ACCT, NAME, EMAIL
One-to-many contacts to ACCT
What is the sql to select the ACCT from table and insert as a new column name ?
I would like to find all of the CID's for ACCT and show them in the record i.e name1, name2, name3
Did I give enough information for a response????