|Subject||Re: Re: [firebird-support] How To Get Entire Linked Group Details|
Thank You So Much, I got exactly the same result what I was expecting.
Thank You So much.
Are you aware of any documents which are avaialble in english, so I could learn this recirsive SQL ?
With Best Regards.
On Monday, 5 October 2015 3:55 PM, "'Norbert Saint Georges' nsg@... [firebird-support]" <email@example.com> wrote:
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')
Norbert Saint Georges
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
E- mail : nsg@...