Hi ~ Iam Noobie ^^ but check this: if you want show only the list of selected items ~ [code] $query = "SELECT * FROM dprices p, temporder t WHERE p.companyname = t.companyname AND p.companyname = '" . $companyname . "' AND p.productsku = t.productsku AND p.price > 0"; $result = mysql_query ($query); if (!$result) { echo "Query ERROR: " . mysql_error (); exit (); } while ($query_data = mysql_fetch_array ($result)) { echo "this item is selected: " . $query_data['productsku'] . " Price: " . $query_data['price'] . "<br />"; } [/code] and if you want show the list of selected items and no selected items [code] $query = "SELECT *, t.productsku as productskuSelected FROM dprices p LEFT JOIN temporder t ON ( p.productsku = t.productsku AND p.companyname = t.companyname) WHERE AND p.companyname = '" . $companyname . "' AND p.price > 0"; $result = mysql_query ($query); if (!$result) { echo "Query ERROR: " . mysql_error (); exit (); } while ($query_data = mysql_fetch_array ($result)) { if ($query_data['productskuSelected'] != NULL) { echo "this item is selected: " . $query_data['productsku'] . " Price: " . $query_data['price'] . "<br />"; } else { echo "this item is not selected: " . $query_data['productsku'] . " Price: " . $query_data['price'] . "<br />"; } } [/code] I hope this code and help you ~