An issue in the database where one table data is known to query another table data

From Tb_xmpcps can find the user name $myrow2[' xmpcps_user '], and then through the user name to find the name in Tb_user, two table nested query is really the first time to do, labor everyone pointing! Why is there a mistake in saying $query2?

   
 
        
  
   .    
 
  

Reply to discussion (solution)

Try connecting the table
SELECT b.* from Tb_xmpcps as A left Ouver joins Tb_user as B on A.xmpcps_user=b.online_user WHERE a.xmpcps_pcid= ' $xmpc _id '

$query 2=mssql_query ("Select b.* from Tb_xmpcps as A left OUTER joins Tb_user as B on A.xmpcps_user=b.online_user WHERE a.xm Pcps_pcid= ' {$xmpc _id} ');

or an error? Why? Say $query2 has a mistake? Please help me look again!

   
 
        
  
   .
 
      
 
      
  
          
 
  

Echo Mssql_get_last_message ();
Let's see what we got.

I ended up with two nested queries to solve, so you can, or thank you for your help!

   
 
        
  
   .    
 
  

