|Subject||Re: Re: [firebird-support] How To Get Entire Linked Group Details|
Sorry, forgot to put SQL for reference.
if I understand the request, something like
select b.description from
select a.* from mygroup a
where a.linked_to_group is not null
exists(select 1 from mygroup b where b.linked_to_group = a.pk_group )
or a.linked_to_group != (select first 1 pk_group from mygroup where linked_to_group is null)
where b.linked_to_group = (select first 1 pk_group from mygroup where description = 'Vishal Group')
On Tuesday, 6 October 2015 9:56 AM, "Vishal Tiwari vishualsoft@... [firebird-support]" <email@example.com> wrote:
Sorry to say, but the below SQL you shared doesn't givbe the sub nodes in the base node, it just gives the first level of nodes and not the enitre node structure i.e. all other nodes below the nodes (i.e. nodes which I get from you SQL as a result ) are missing.
Would you please check again ?
With Best Regards.
On Monday, 5 October 2015 6:53 PM, "'Norbert Saint Georges' nsg@... [firebird-support]" <firstname.lastname@example.org> wrote:
Recursive Trees with Firebird ?
Norbert Saint Georges
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
E- mail : nsg@...