Tema: Re: SQL query klausimas
Autorius: If
Data: 2011-03-02 13:33:26
Tpfuuuuuuuuuu BUG BUG BUG>SORRY..... is inercijos suklydau,. taip turi buti

SELECT * FROM Asmenys AS Asmenys1 WHERE ' jei asmenu per daug sioje vietoje
atliekam filtracija (Pvz: Asmenys1.Vardas LIKE PerParametra...............)
 EXISTS
(SELECT * FROM Asmenys AS Asmenys2 WHERE Asmenys1.MotinosId =
Asmenys2.Id OR Asmenys1.TevoId = Asmenys2.Id EXISTS
(SELECT * FROM Asmenys AS Asmenys3 WHERE Asmenys2.MotinosId =
Asmenys3.Id OR Asmenys2.TevoId = Asmenys3.Id EXISTS
(SELECT * FROM Asmenys AS Asmenys4 WHERE Asmenys3.MotinosId =
Asmenys4.Id OR Asmenys3.TevoId = Asmenys4.Id EXISTS
(SELECT * FROM Asmenys AS Asmenys5 WHERE Asmenys4.MotinosId =
Asmenys5.Id OR Asmenys4.TevoId = Asmenys5.Id EXISTS
(SELECT * FROM Asmenys AS Asmenys6 WHERE Asmenys5.MotinosId =
Asmenys6.Id OR Asmenys5.TevoId = Asmenys6.Id EXISTS
(SELECT * FROM Asmenys AS Asmenys7 WHERE Asmenys6.MotinosId =
Asmenys7.Id OR Asmenys6.TevoId = Asmenys7.Id))))))

Gal dar kur suklydau netikrinau , galima nesunkiai parasyti ir dinamini SQL
su nurodomu giminystes rysio gyliu, tik NEDRASKYKIT LENTU!!!!!!!!!!!!!! ARBA
JEI PASTATUI NEMOKATE RASTI TINKAMU LANGU< NEVERSKITE PAMATU :)