I can run this query:

select * from picker_data_entity

I can run this query:

select * from bip

but, when I am trying to run this query:

select * from picker_data_entity join bip on bip.id = picker_data_entity.bipId 

or this query:

select "*" from picker_data_entity join bip on "bip.id" = "picker_data_entity.bipId"

I get this error:

ERROR:  column picker_data_entity.bipid does not exist
LINE 1: ...ct * from picker_data_entity join bip on bip.id = picker_dat...
                                                             ^
HINT:  Perhaps you meant to reference the column "picker_data_entity.bipId". 

SQL state: 42703
Character: 55

Please help me run this simple join query. Thank you!