组合两个SQL - Combine two SQL

Combine two SQL

本文关键字：两个 SQL 组合 | 更新日期: 2023-09-27

我想合并以下SQL查询。现在我给他们打了两次电话，但我想我可以一次搞定。我试过了，但找不到解决办法。谁能提供给我的组合SQL。我知道我使用sql而不是MISQLI或PDO。

$lsel_first = mysql_query("select * from table_test WHERE owner = '$id' AND ownersecond = '0' AND catogory = '1' AND type = '$car[id]' AND caseB = '0' AND (timeback < TIMESTAMP(NOW()) OR timeback = '0000-00-00 00:00:00') ");
$first = mysql_num_rows($lsel_first);

$lsel_second = mysql_query("select * from table_test WHERE ownersecond = '$id' AND catogory = '1' AND type = '$car[id]' AND caseB = '0' AND (timeback < TIMESTAMP(NOW()) OR timeback = '0000-00-00 00:00:00')  ");
$second = mysql_num_rows($lsel_second);

此处:

mysql_query("select * from table_test 
WHERE ((owner = '$id' AND ownersecond = '0') OR ownersecond = '$id') 
AND catogory = '1' AND type = '$car[id]' AND caseB = '0' 
AND (timeback < TIMESTAMP(NOW()) OR timeback = '0000-00-00 00:00:00') ");

使用union

select * from table_test WHERE ownersecond = '$id' AND catogory = '1'  
AND type = '$car[id]' AND caseB = '0' AND (timeback < TIMESTAMP(NOW())  
OR timeback = '0000-00-00 00:00:00') union select * from table_test  
WHERE ownersecond = '$id' AND catogory = '1' AND type = '$car[id]'  
AND caseB = '0' AND (timeback < TIMESTAMP(NOW())  
OR timeback = '0000-00-00 00:00:00')