how to put these 2 queries into 1?

[dragon_sa]

// get working staff from staff table
$staffSQL=mysql_query("SELECT * FROM staff WHERE ".$weekday." != 'off' AND onLEAVE='no' AND ACTIVE='yes' ORDER BY staffID ASC");

// get appointments for selected date from appointmen table
$existSQL=mysql_query("SELECT * FROM appointment WHERE date='$sqlDATE' AND staffID='$staffID'");

 

I currently have these 2 queries running in a script with the top one first then a while loop of results for that, then a for loop to list appointment times, then the second query with another while loop for that, the problem with that is when it finds appointments on the same day it runs lists the reults twice, so I want to merge the 2 sql queries together and use the original while loop for the result, how can I join or link these 2 queries into 1

 

the data i am pulling from each is as follows

query 1

	$name=$staff['staffNAME'];
	$avail=$staff[$weekday];
	$staffID=$staff['staffID'];

 

query 2

	$resSTART=$appointV['dateTIME'];
	$length=$appointV['totalTIME'];

[fenway]

You need a JOIN, is all.