SELECT cont.msg_id, cont.msg_text, CONCAT_WS(', ', a1.address, a2.address)
FROM CONTENT AS cont, ADDRESS AS a1, ADDRESS AS a2 WHERE cont.msg_id =
a1.msg_id AND cont.msg_id = a2.msg_id;
Many thanks to salle in efnet #mysql for teaching me this trick ;-)
> Hello,
>
> I am relatively new with MySQL
the last one you
can't reorder
++-+---+
that's as close as I could figure
-Original Message-
From: Matthieu Paindavoine [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 7:23 AM
To: [EMAIL PROTECTED]
Subject: Re: Collapsing queries
Thank you for yo
Thank you for your help but this is not quite what I wanted. I tried
your solution, but it raises the following problem:
It would return
1 | Hello World | Foo
1 | Hello World | Bar
and if I neglect to look at the msg_id in the first column (which I
voine
Sent: Thursday, June 14, 2001 10:00 PM
To: [EMAIL PROTECTED]
Subject: Collapsing queries
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: ms
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 table
