PHPMYSQL连接多个表

PHP / MYSQL连接多个表

您应该可以使用以下方法获得结果：

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 |