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
3,1,3
Result wanted:
1,Dave,Bob
2,Bob,Simon
3,Dave,Simon
There are a whole bunch of fields I would want to pull from table1, but
for this example I have just used name. Can anyone point me in the right
direction?
--
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]