mysql join three tables not duplicate value

Question

I have the following tables

--subscribers--

id
name
e-mail

--categories--

id
subscriber_id
cat1
cat2
... so on

--messages--

id
title
message
cat1
another field
...

My query needs to return title, message and subscriber mails. Every subscriber can get many messages.

My query returns duplicate e-mails. I would like to get:

e-mail1 - title1, message1
e-mail2 - title1, message1, title2, message2 so on
e-mail3 - title1, message1, title2, message2, title3, message3

Now I have:

e-mail1 - title1, message1
e-mail2 - title1, message1
e-mail2 - title2, message2
e-mail3 - title1, message1
e-mail3 - title2, message2

How to dela with it? Thanks for any help.

You can achive that by [GROUP_CONCAT](http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat). But without seeing your query... — juergen d, May 12 '12 at 13:46

Venu · Accepted Answer · 2012-05-12T13:48:50.513

0

Use GROUP BY email to get the unique email ids.

Use GROUP_CONCAT(title), GROUP_CONCAT(message) to fetch all messages

edited May 12 '12 at 13:48

answered May 12 '12 at 13:41

Venu

1 Answers1