var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query output
There is one table and have self reference . I want some output from that table as per some condition.
If I give input PKID=1 then output must be like below as I need only PKAID..
If I give input PKID=3 then output must be like below as I need only PKAID..
If I give input PKID=6 then output must be like below as I need only PKAID..
It seems here will be used recursive type query or pl/sql but how not getting
Please suggest some solution for the same...
there is no recursive functionality in mysql
Originally Posted by Pawan Kumar
there is no pl/sql language in mysql
by creating procedure or function?if yes what will be logic?
run the same query until you find there are no more child rows. Meaning:
and keep running this til there are no rows returned.
select fkaid from table where pkaid =&pk
select fkaid from table where pkaid = "the fkaid you just got"