Ich kann nur empfehlen, gleich die
SQL-92 Join-Syntax zu lernen.
SQL-Code:
-- alte Syntax (implicit join notation)
SELECT * FROM Persons, Names WHERE Names.NameID=Persons.PersonID AND Names.SurnameID=:ID
-- neue, besere Syntax (explict join notation)
SELECT * FROM Persons INNER JOIN Names ON Names.NameID=Persons.PersonID WHERE Names.SurnameID=:ID