using parent alias in sub query postgresql

Question

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.

The syntax is correct and will work in Postgres. See this online example: rextester.com/NBZS5678 What exactly does not work for you? What is the exact error message you get (edit your question, do not post code or additional information in comments). — user330315
– user330315, Commented Sep 18, 2017 at 8:49

user7612612 · Accepted Answer · 2017-09-18 08:21:09Z

1

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
                      );

answered Sep 18, 2017 at 8:21

user7612612

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

That is something entirely different.

Collectives™ on Stack Overflow

using parent alias in sub query postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related