Izinhlelo zokuphathwa kwedathabheyisi yobudlelwano ezisekelwe ku-SQL zilungele ingxenye kuphela imibuzo elandelanayo noma ephindaphindayo. Ezinye izinhlelo ezifana ne -ArangoDB zilungele kangcono lokhu (kube nenkulumo enhle ngalokhu ku -GOTO 2016 ). Kodwa-ke, kungenzeka futhi ukudala imibuzo ephindaphindayo ku-SQL usebenzisa i-Common Table Expressions , okukuvumela, isibonelo, ukuthi ubuze amatafula abazali/izingane akudala kubo bonke okhokho nenzalo.
KuPostgreSQL kubukeka kanjena, ngokwesibonelo:
0672c4761d202a35a9059fa137ace7c3
Uma ufuna ukuthola zonke izingane zento ethile_id, usebenzisa i-Common Table Expressions:
0672c4761d202a35a9059fa137ace7c3
Ukubuza abazali nakho akunankinga:
0672c4761d202a35a9059fa137ace7c3