I just started using CodeIgniter and would like to execute the query below. But I don't know how to write this using CodeIgniter. This query successfully executes in phpMyAdmin.
SELECT sales.sales_id
, sales.sales_date
, sold_item.item_id
, sold_item.quantity
, general_sales.cust_id
FROM sales
JOIN general_sales ON sales.sales_id =general_sales.general_sales_id
JOIN sold_item ON general_sales.general_sales_id= sold_item.sales_id
WHERE sales_date= ?