mailing label query

cbeshears · #1 (**permalink**) 06-26-06, 14:40

I have database of names and mailing address that I want to use to generate mailing labels. Some of the people who are in the database have the same address as others (they live in the same house) but they have their own entry. How can I generate a query that will list all the addresses without duplicating itself and show all the people who live in that one household?

For example:
John, Sue, and Mary Smith
123 Main Street
Town, ST 12345

Thank you for your help in advance.

r937 · #2 (**permalink**) 06-26-06, 15:50

use GROUP_CONCAT on the name field(s) when using GROUP BY on all the address fields

cbeshears · #3 (**permalink**) 06-26-06, 16:57

I can't quite figure out the syntax. Can you tell me what I'm doing wrong?

Code:

SELECT GROUP_CONCAT(lname, fname) FROM roster GROUP BY lname

Thanks.

r937 · #4 (**permalink**) 06-26-06, 17:13

"list all the addresses without duplicating itself" == GROUP BY address fields

also, if you want both lastname and firstname concatenated in the GROUP CONCAT, then you need a separate CONCAT function for them

Code:

SELECT GROUP_CONCAT(CONCAT(fname,' ',lname)) as who
     , address fields
  FROM roster
GROUP
    BY address fields

cbeshears · #5 (**permalink**) 06-26-06, 17:24

Perfect. Thank you very much.

Internet Services

Web Development

Digital Marketing

Consumer Tech