Thanks Got it
Regards,
Jitendra
On Fri 22 Feb, 2019, 4:03 PM mariusz On Fri, 22 Feb 2019 13:23:11 +0530
> Jitendra Loyal wrote:
>
> > I find that the RECURSIVE can be used only once in a CTE.
> >
> > I have the following use-case where there is a hierarchy of
> > store_groups, and then ther
Thanks Andrew
I will try this and revert; I was specifying RECURSIVE for the second CTE
as well.
Regards,
Jitendra
On Fri, 22 Feb 2019 13:23:11 +0530
Jitendra Loyal wrote:
> I find that the RECURSIVE can be used only once in a CTE.
>
> I have the following use-case where there is a hierarchy of
> store_groups, and then there are stores associated with a
> store_group. Requirement is to ensure that a store ca
> "Jitendra" == Jitendra Loyal writes:
Jitendra> I find that the RECURSIVE can be used only once in a CTE.
RECURSIVE can be specified only once, but it applies to all CTEs at that
level. That is to say, RECURSIVE qualifies the preceding WITH, _not_ the
following CTE.
Note that just specify
I find that the RECURSIVE can be used only once in a CTE.
I have the following use-case where there is a hierarchy of store_groups,
and then there are stores associated with a store_group. Requirement is to
ensure that a store can be used only once in a store group hierarchy.
Following definitions
