How to merge output from two select statements?

[Dexxter]

Can anyone help here? I'm stuck at a step in this process, and I'm a little fried from staring at the comp for 8 hours already on this one thing...

the two selects below need to be returned as a single table. Can I Concat? Union? Join?

Can I somehow join the results of the select statements?

and anywhere you see "4" will be a user variable.

 
select d.dname Department, e.fname First, e.lname Last
       from department as d, employee as e
       where d.mgrssn = e.ssn AND d.dnumber=4;
 
select count(distinct(e.ssn)) Number_of_Employees,
       count(distinct(works_on.pno)) Number_Of_Projects_Under_Dept,
       Sum(works_on.hours) Hours_Worked
       FROM employee AS e, (works_on JOIN project ON works_on.pno=project.pnumber)
       WHERE project.dnum=4 AND e.dno=4 AND e.ssn=works_on.essn;
 

[omerbutt]

yes you can if you have some kind of key that is saved in both the tables and is unique

table_A name ,age, email, user_id
table_B picture ,website , contact info, user_id

$Q="select * from 
   table_A as a, 
   table_B as b
where 
   a.user_id=b.user_id ";
 

<?php 
  if(mysql_num_rows(RESULT_SET)){
    while($f=mysql_fetch_array(RESULT_SET)){
      echo $f['name'].$f['Picture'];
    }
  }
?>