#1054 - Unknown column 'payments.date' in 'where clause'
SELECT issue.bill_id as 'Bill id', items.i_code as 'Item code', issue.qtt as 'Qtt', issue.date as 'Date', issue.bill_serial as 'Bill number',issue.qtt*trip.h_price as 'Total' from issue INNER JOIN items ON issue.item_id=items.i_id INNER JOIN trip ON issue.bill_id=trip.bill_id AND issue.item_id=trip.item_id WHERE issue.c_id=1 AND payments.date BETWEEN '2015-01-20 11:16:43' AND '2016-01-29 11:16:43'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)