In Postgres,Create View Using Join Condition

Question

I have calendar table with columns(id,agent_id,date,location) and agent table with columns(id,name,phone_number,email). I need to create a view of calendar table with additional column(agent_email),where agent_email is from agent table email column as same as agent_id in calendar table is id from agent table.

I have tried as in above screenshot,but instead of agent_email in table column ,I have ?column?.

Can you post the actual SQL statements to create your tables? — SebDieBln
– SebDieBln, Commented Dec 8, 2022 at 10:24
@SebDieBln I have already created those both tables(calendar,agent) — zoro
– zoro, Commented Dec 8, 2022 at 10:28
Well, but I haven't. And I could only help you once I have :-) — SebDieBln
– SebDieBln, Commented Dec 8, 2022 at 10:30
Please do not post code as images. See here for more details why: meta.stackoverflow.com/questions/285551 — user330315
– user330315, Commented Dec 8, 2022 at 11:11

SebDieBln · Accepted Answer · 2022-12-08 17:43:24Z

1

select calendar_events.*, agents.email
from calendar_events
left outer join agents on calendar_events.agent_id=agents.id;

This gives my expected answer ,

columns :

id | agent_id | date | location | agent_email

edited Dec 8, 2022 at 17:43

SebDieBln

3,4891 gold badge12 silver badges25 bronze badges

answered Dec 8, 2022 at 11:00

zoro

1098 bronze badges

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

Collectives™ on Stack Overflow

In Postgres,Create View Using Join Condition

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