Hi, I am certain this is possible with a single query, but I have had
not joy looking on google or using trial and error in MySQL...
Table1: id, name
Table2: id,member1,member2
In Table2 the member1 and member2 are the ID's from Table1
Table1:
1, Dave
2, Bob
3, Simon
Table2:
1,1,2
2,2,3
On 10/8/06, Critters [EMAIL PROTECTED] wrote:
Hi, I am certain this is possible with a single query, but I have had
not joy looking on google or using trial and error in MySQL...
Table1: id, name
Table2: id,member1,member2
In Table2 the member1 and member2 are the ID's from Table1
Table1:
1,