CODEWITHSUNDEEP
postgresql
Angger
Angger

Reputation: 805

using parent alias in sub query postgresql

I want to use alias in sub query but seems alias is not recognized in subquery

SELECT M.name, (select code from menus where menus.id = M.parent_id) as parent_code
    FROM menus as M;

How do I achieve this?

I used to use oracle and this query works.

Upvotes: 0

Views: 479

Answers (1)

user7612612
user7612612

Reputation:

Try this

SELECT m.name
FROM menus as m
WHERE m.parent_id in (
                        select m1.parent_id 
                       from menus as m1 
                       where m.parent_id = m1.parent_id
                      );

Upvotes: 1

Related Questions