Postgres Invalid Reference to FROM Clause

Question

I am having a hard time finding what I am doing wrong here.

    select * from prog_log as g0, order_line as g1, logstat as g2
    inner join channel as g3 on g3.chn_serial = g0.log_chn_id

I am getting the following error:

    invalid reference to FROM-clause entry for table "g0"
    LINE 2: inner join channel as g3 on g3.chn_serial = g0.log_chn_id
                                                ^
    HINT:  There is an entry for table "g0", but it cannot be referenced from this part of the query.

From what I've read I need to do some kind of join on g0, g1, and g2, but my database doesn't have a common column between them, so I can't do a join.

Any help would be greatly appreciated.

Don't mix the ancient implicit joins and explicit JOIN operators — user330315
– user330315, Commented Aug 31, 2020 at 17:32

AdamKG · Accepted Answer · 2020-08-31 17:28:13Z

3

Commas in Postgres bind more weakly than JOIN expressions; change each comma in the FROM clause to CROSS JOIN. See the note in the relevant section of the docs.

answered Aug 31, 2020 at 17:28

AdamKG

14.1k3 gold badges41 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Postgres Invalid Reference to FROM Clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related