FB: Hilfe bei Join

[omata]

SQL-Code:

SELECT *
FROM customer c
INNER JOIN customer_adc ca
  ON c.id = ca.customerid
WHERE enddate = (SELECT MAX(enddate)
                 FROM customer_adc
                 WHERE customerid = ca.customerid)