SELECT t1.attribut1, t2.attribut2
FROM table1 t1, table2 t2
SELECT Parent.Prenom, Enfant.Prenom
FROM Parent, Enfant
WHERE Enfant.Nom=Parent.Nom
SELECT attribut1 AS a1, attribut2 AS a2
FROM table