Hot add two seperete table fealds to one select query

See more:

C#

MySQL

ODBC

I try to extract data using bellow query , it sow this error after execution . please help me to correct this query.

Error:

#1054 - Unknown column 'payments.date' in 'where clause' 

My query;

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'