我该如何编写包含CodeIgniter查询生成器中的连接的查询？

Question

我想写的查询是

SELECT Equipment.Name, Equipment.EquipmentTag, LoanedOut.StudentNumber, LoanedOut.DueDate 
FROM Equipment, LoanedOut 
WHERE Equipment.EquipmentRecordID = LoanedOut.EquipmentRecordID AND LoanedOut.StudentNumber = 040828055 

我无法弄清楚如何使用CodeIgniter的查询生成器来做到这一点，我有最好的到目前为止是

$this->db->select('Equipment.Name, Equipment.EquipmentTag, LoanedOut.StudentNumber, LoanedOut.DueDate'); 
$this->db->from('Equipment e, LoanedOut l'); 
$this->db->join('l', 'e.EquipmentRecordID = l.EquipmentRecordID')->join('l', 'l.StudentNumber', $studentNumber); 

Answer 1

这会给你你想要的东西//

$sql = 'SELECT e.Name,e.EquipmentTag,l.StudentNumber,l.DueDate FROM Equipment e LEFT JOIN LoanedOut l ON e.EquipmentRecordID = l.EquipmentRecordID WHERE l.StudentNumber = "040828055"' 
$query = $this->db->query($sql);