multiple select statements in one sql

Anon

I'm trying to list all the fields for my records in one table. The problem is I have fields for these records in 3 different tables in my database. How can I take all the fields from these 3 tables in my database and list them all together in one table?

Could I go:
$sql="SELECT name, number, address
FROM teacher
AND SELECT teacherStrandID
FROM teacherStrand
WHERE resourceID=$resourceID";

Anon

$sql="SELECT resourceID, name, school, address, city, zip, work, home, fax, email, URL, teacherStrandID
FROM teachers, teacherStrand
ORDER BY '$orderBy'";

$result = mysql($dbName, $sql);

while($row=mysql_fetch_row($result)){
$resourceID=$row[0];
$name=$row[1];
$school=$row[2];
$address=$row[3];
$city=$row[4];
$zip=$row[5];
$work=$row[6];
$home=$row[7];
$fax=$row[8];
$email=$row[9];
$URL=$row[10];
$teacherStrandID=$row[11];

print"<tr>";
print"<td valign=top>$resourceID </td>";
//print"<td valign=top><TEXTAREA NAME=\"address\" ROWS=3 COLS=20 WRAP>$reasons </TEXTAREA></td>";
print"<td valign=top>$name </td>";
print"<td valign=top>$school </td>";
print"<td valign=top><TEXTAREA NAME=\"address\" ROWS=3 COLS=15 WRAP>$address</TEXTAREA></td>";
print"<td valign=top>$city </td>";
print"<td valign=top>$zip </td>";
print"<td valign=top>$work </td>";
print"<td valign=top>$home </td>";
print"<td valign=top>$fax </td>";
print"<td valign=top>$email </td>";
print"<td valign=top>$URL </td>";
print"<td valign=top>$teacherStrandID&nbsp</td>";
print"<td valign=top><a href=\"editTeachers.php?section=edit&action=edit&resourceID=$resourceID\">edit</a></td>";
print"<td valign=top><a href=\"editTeachers.php?section=delete&action=delete&resourceID=$resourceID\">delete</td>";
print"</tr>";
}

Anon

Have a look at sql joins (search the web, for tutorials, have a look in the manual for you sql server or find a book on sql).

[deleted]

It would be really cool if you also told us what the problem is.

Anon

Thank you!