I've figured out (with some help) how to query two tables at the same time. In order to get a corresponding CompanyName with a specified ContactID I created a SQL query that selects both tables ($table_name1,$table_name2) and then selects contacts.CompanyID = '$CompanyID'. The result is a match for data in the contacts table, but the data from the company table is the same no matter which ContactID I select. I have two CompanyNames (with unique CompanyID) and two separate contacts each one having a different CompanyID associated. What am I doing wrong? Steve <? error_reporting(5); $db_name = "crm"; $table_name1= "contacts"; $table_name2= "company"; $connection = @mysql_connect("xxxx", "xxxx", "xxxx") or die("Couldn't connect."); $db = @mysql_select_db($db_name, $connection) or die("Couldn't select database."); $chk_id = "SELECT ContactID FROM $table_name1 WHERE ContactID = $ContactID"; $chk_id_res = @mysql_query($chk_id,$connection) or die("Couldn't execute query."); $chk_id_num = mysql_num_rows($chk_id_res); $sql1 = "SELECT FirstName, LastName,WorkPhone, HomePhone, EmailName, Birthday FROM $table_name1 WHERE ContactID = '$ContactID' "; $sql2 = "SELECT CompanyName,WebSite FROM $table_name1,$table_name2 WHERE contacts.CompanyID='$CompanyID' "; $result_1 = @mysql_query($sql1,$connection) or die("Couldn't execute query."); $result_2 = @mysql_query($sql2,$connection) or die("Couldn't execute query."); while ($row = mysql_fetch_array($result_1)) { $FirstName = $row['FirstName']; $LastName = $row['LastName']; $WorkPhone = $row['WorkPhone']; $HomePhone = $row['HomePhone']; $EmailName = $row['EmailName']; $Birthday = $row['Birthday']; } while ($row = mysql_fetch_array($result_2)) { $CompanyName = $row['CompanyName']; $WebSite = $row['WebSite']; } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]