查询mysql到laravel

Question

我用MySQL编写这个查询

SELECT driver.nama_driver,pengiriman.status_pengiriman FROM driver
 LEFT JOIN pengiriman ON pengiriman.user_driver = driver.user_driver WHERE 

driver.user_driver="12aad" and pengiriman.status_pengiriman is null OR 

driver.user_driver="12add" and pengiriman.status_pengiriman = "Terkirim"`  

它什么也没有显示，因为我选择了driver.user_driver，他不在pengiriman表中，但在Laravel中它显示了一些东西，有人可以帮助我吗?我想要输出什么也没有显示。

​

​

Answer 1

我想你漏掉了括号：

SELECT driver.nama_driver,pengiriman.status_pengiriman
FROM driver
LEFT JOIN pengiriman ON pengiriman.user_driver = driver.user_driver WHERE 
   ( driver.user_driver="12aad" AND pengiriman.status_pengiriman IS NULL )
   OR ( driver.user_driver="12add" AND pengiriman.status_pengiriman = "Terkirim"`)