您应该可以使用以下方法获得结果：
select t.ticketid, date_format(r.datenew, '%Y-%m-%d') datenew, c.name, p.payment, r.totalfrom tickets tleft join RECEPTS r on t.id = r.idleft join CUSTOMERS c on t.customer = c.idleft join payments p on t.id = p.RECEIPT and r.id = p.RECEIPT
参见带有演示的SQL Fiddle
结果：
| TICKETID | DATENEW | NAME | PAYMENT | TOTAL |---------------------------------------------------| 29 | 2012-12-03 | John | cash | 22.57 || 76 | 2012-12-03 | Helen | debt | 33.98 |
