Two inner joins

This article is tagged with: Two inner joins and mysql

two inner joins

SELECT
c.*, i.*, a.*
FROM
invoices i
INNER JOIN
client c
ON
i.clientid = c.clientid
INNER JOIN
address a
ON
a.clientid = c.clientid
WHERE
i.id = 21

This article is tagged with: Two inner joins and mysql