如何在所选日期之间从不同的表中选择值 - how do i select values from different table between selected date

how do i select values from different table between selected date

本文关键字：选择之间日期 | 更新日期: 2023-09-27

这就是我所做的。我尝试了一个sql查询，用于从具有相同区域的两个多个表中获取两个日期之间的值。但我得到的结果是$from_date和$to_date的日期相似。但我需要所有满足条件的值，即BETWEEN '$from_date' AND '$to_date'。

SELECT DISTINCT a.amount_in_sqft, b.price_in_sqft, a.category
FROM sale_apartment AS a
INNER JOIN reqr_apartments AS b
    on a.area = b.area AND a.category = b.category
WHERE a.area='$area'
  AND b.category BETWEEN '$from_date' AND '$to_date'
GROUP BY a.category

在没有任何聚合函数的情况下使用GROUP BY子句似乎很奇怪。也许尝试删除它。

试试这个：

SELECT distinct a.amount_in_sqft, b.price_in_sqft, a.category 
FROM sale_apartment AS a 
INNER JOIN reqr_apartments AS b
    ON a.area = b.area and a.category = b.category
WHERE a.area = '$area' 
  AND b.category BETWEEN '$from_date' AND '$to_date' 
GROUP BY a.amount_in_sqft, b.price_in_sqft, a.category