php sql merge 2查询

Question

我有两个问题，一个接一个：

$sql_result8 = mysql_query("SELECT * FROM properties WHERE c4='$id'", $db); $charges = mysql_num_rows($sql_result8); 
$sql_result8 = mysql_query("SELECT * FROM vehicles WHERE c4='$id'", $db); $charges = $charges + mysql_num_rows($sql_result8);

我需要什么样的查询来合并这些内容？某种连接？友联市?

Answer 1

SELECT * FROM properties p, vehicles v WHERE p.c4 = v.c4 AND p.c4 = '$id'

Answer 2

尝尝这个

SELECT * FROM properties JOIN vehicles USING (c4) WHERE c4='$id'

Answer 3

如果您只想找出两个查询返回的行数或行数，而不想显示实际的列，则可以使用以下命令：

$sql_result8 = mysql_query(
    "SELECT 
         ( SELECT COUNT(*) FROM properties WHERE c4='$id' )
       + ( SELECT COUNT(*) FROM vehicles WHERE c4='$id' )
    ", $db );