mysql - 在 mysql 输出中连接两个表显示为 null

Question

我试图在 MySQL 中连接两个表，但输出显示为空。

供应商

id vname        contactno    email                 address  status
1  raja         715487240  kobi.ram@hotmail.com   badulla    2
2  janarthan    77722222   jaranthan@gmail.com    Hali-ela   1

purchase

id   vendor_id    date         total     pay    due  payment_type

400     2        2018-10-08    10000    8000    2000     2
401     2        2018-10-12    12000    6000    6000     2

SQL查询

select
    v.vname, p.id, p.date, p.total, p.pay, p.due, p.payment_type
from purchase p, vendor v
WHERE p.vendor_id = v.id and date BETWEEN 2018-10-01 and 2018-10-31

Answer 1

我认为你应该使用单引号进行日期比较，并告别老式的连接，更改为如下新格式的连接

SELECT v.vname,p.id,p.date,p.total,p.pay,p.due,p.payment_type 
FROM purchase p 
INNER JOIN vendor v ON p.vendor_id = v.id 
AND p.date BETWEEN '2018-10-01' and '2018-10-31'

fiddle :http://sqlfiddle.com/#!9/984801/1