php - 选择所有字段到具有相同id_ref的两个不同表中

我有两张桌子。销售和销售。这两个表都有共同的id_ref。所以我想得到的是从rsales中选择所有这些值，而salessumarry具有相同的id_ref。到目前为止，这是我的代码。但这没有运行。我不知道这是什么问题。

$result1 = mysql_query("
    SELECT
    salessumarry,rsales.*,
    FROM salessumarry
    LEFT JOIN rsales ON rsales.receipt = salessumarry.receipt
    WHERE (register_mode='sales') AND (date BETWEEN '$a' AND '$b')GROUP BY receipt");

最佳答案

您正在使用多余的逗号。请参阅此查询和测试。

SELECT
  salessumarry,
  rsales.*
FROM
  salessumarry
  LEFT JOIN rsales
    ON rsales.receipt = salessumarry.receipt
WHERE (register_mode = 'sales')
  AND (DATE BETWEEN '$a'
    AND '$b')
GROUP BY receipt