FROM payment INNER JOIN income,bank_dep
You can have more tables in FROM, like:
FROM payment,income,bank_dep
, but you can't have other than one single table after JOIN, and you have two. And you never can have an operation like
a=b=c
, but you have You need to split the statement across multiple joins:
SELECT payment.indate,payment.opening_balance,payment.purpose,payment.amount,income.indate,income.opening_balance,income.purpose,income.amount,bank_dep.indate,bank_dep.balance_opening,bank_dep.bank,bank_dep.amount
FROM (payment
INNER JOIN income ON payment.indate=income.indate)
INNER JOIN bank_dep ON income.indate=bank_dep.indate