JOIN Tables

[unemployment]

How do I join these queries and is it best practice?

 

$e_query = mysql_query("SELECT `employeeid`, `userid`, `companyid`, `function`, `timestamp` FROM `employees` WHERE `companyid` = '${c_row['companyid']}'");

 

$e_row = mysql_fetch_assoc($e_query);

 

$u_query = mysql_query("SELECT `id`, `firstname`, `lastname`, `username`, `accounttype` FROM `users` WHERE `id` = '${e_row['userid']}'");

 

$u_row = mysql_fetch_assoc($u_query);

 

$eQ = "SELECT `capitalrequested` FROM `eQuestions` WHERE `userid` = '${u_row['id']}'";

 

$eQRes = mysql_query($eQ);

 

$reQ = mysql_fetch_assoc($eQRes);

 

$iQ = "SELECT `capitalavailable` FROM `iQuestions` WHERE `userid` = '${u_row['id']}'";

 

$iQRes = mysql_query($iQ);

 

$riQ = mysql_fetch_assoc($iQRes);