Programming Forums - View Single Post - MySQL

Arla · Mar 23rd, 2008, 11:42 PM

How about

Select a.name as user1, b.name as user2
  from $table_user a
         ,$table_user b
         ,$table_match c
  where a.user_id = c.user_id1
  and     b.user_id = c.user_id2

I think that should do it (bit tired right now, so might have missed something)

Mar 23rd, 2008, 11:42 PM	#5
Arla Hobbyist Programmer Join Date: Mar 2005 Posts: 156 Rep Power: 4	Re: MySQL - Basic Combining Of Queries How about (Toggle Plain Text) Select a.name as user1, b.name as user2 from $table_user a ,$table_user b ,$table_match c where a.user_id = c.user_id1 and b.user_id = c.user_id2 Select a.name as user1, b.name as user2 from $table_user a ,$table_user b ,$table_match c where a.user_id = c.user_id1 and b.user_id = c.user_id2 I think that should do it (bit tired right now, so might have missed something)