Hello,
I am relatively new with MySQL (and SQL for that matter) and I couldn't
find much reference to my problem in earlier posts.
Let's say I have 2 tables,
CONTENT: msg_id, msg_text
ADDRESS: msg_id, address
and I receive the msg "Hello World" addressed to the twins Foo and Bar.
now my tables look like this:
CONTENT:
1 Hello World
ADDRESS:
1 Foo
1 Bar
I am desperatly looking for a sql statement that would produce
1 | Hello World | Foo, Bar
Is there such a thing??
I welcome any suggestions,
Thanks
Matthieu
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php