Hi Dan,
CREATE TABLE temp.parentchild
(
parent varchar(10),
child varchar(10)
)
INSERT INTO temp.parentchild( parent, child ) values ('Bart', 'Lisa');
INSERT INTO temp.parentchild( parent, child ) values ('Homer', 'Marge');
INSERT INTO temp.parentchild( parent, child ) values ('Marge', 'Bart');
INSERT INTO temp.parentchild( parent, child ) values ('Abe', 'Homer');
INSERT INTO temp.parentchild( parent, child ) values ('Ape', 'Abe');
DECLARE C CURSOR FOR
WITH RECURSIVE family(p,c) AS
( SELECT parent, child
FROM temp.parentchild
WHERE parent = 'Homer'
UNION ALL
SELECT parent, child
FROM temp.parentchild, family
WHERE family.c = parentchild.parent
) SELECT * FROM FAMILY
Works for me as expected... (in SQL Studio)
Bart Lisa
Marge Bart
Homer Marge
Normally you should be able to have it as a query without
the "DECLARE C CURSOR FOR", but this gives me syntax error...
regards
Wolf
________________________________________________________________
Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
