Try this:
SELECT * FROM content, address WHERE content.msg_id = address.msg_id
If I understand what your asking for, you want a JOIN. If I don't
understand, forgive me, it's late... :)
Tyrone
-Original Message-
From: matteo [mailto:matt@web]On Behalf Of Matthieu Paindavoine
Sent:
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
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 your help but this is not quite
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