Collapsing queries

2001-06-15 Thread Matthieu Paindavoine
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

Re: Collapsing queries

2001-06-15 Thread Matthieu Paindavoine
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