mysql - 如何使用 $this->db 编写以下 sql 查询

Question

SELECT Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders
LEFT JOIN Shippers
ON Orders.ShipperID=Shippers.ShipperID
GROUP BY ShipperName; 

Answer 1

你可以试试这个:

$this->db->select('Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders');
$this->db->join('Shippers', 'Orders.ShipperID = Shippers.ShipperID', 'left');
$this->db->group_by('ShipperName');
$getResult=$this->db->get('ShipperName');