mysql> select a.accountnumber,a.ornumber,a.transactiondate,a.yearmonth,b.trandescription,c.centername from subscriberaccounts=a inner join transactioncodes=b inner join paymentcenters=c on a.paymentcenterid=c.paymentcenterid on a.transactioncode=b.transactioncode;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on a.transactioncode=b.transactioncode' at line 1
mysql>