-- asc	- Recherche des ascendants

DROP TABLE  IF EXISTS Parents;
CREATE TABLE Parents
( Pere CHAR(10),
  Mere CHAR(10),
  Enfant CHAR(10));

-- population de la table
INSERT INTO Parents VALUES ('Jean', 'Claire','Paul');
INSERT INTO Parents VALUES ('Jean', 'Nadia', 'Claire');
INSERT INTO Parents VALUES ('Paul','Blandine',  'Zoee');
INSERT INTO Parents VALUES ( 'Zoile','Claire', 'Louis');
INSERT INTO Parents VALUES ('Yvan', 'Zoee',  'Julia');
INSERT INTO Parents VALUES ('Louis', 'Julia', 'Adrien');


/*


         Blandine 
                  \   Zoee
Clara            /        \  Julia
       \    Paul           /       \
       /              Yvan         /  Adrien
Jean                             /
     \   Claire                /
     /         \    Louis    /
Nadia          / 
         Zoile
*/


/*
 aieul    |   enfant   
------------+------------
 Yvan       | Julia     
 Zoee       | Julia     
 Paul       | Julia     
 Blandine   | Julia     
 Jean       | Julia     
 Clara     | Julia    

*/
