Can a database view be created from multiple selects? For instance row 1 is entirely from 1 table and row 2 is from another

Question

Let's say I have 2 tables

People (id, name)
Dogs (id, name)

Can a view be created that contains all the dog names and all the people names so that for instance if I wanted to count how many entities are called Toby I'd have to query just the view?

Ideally it'd look something like

John - where John came from the People table
Toby - and Toby came from the dogs table

I'm using a PostgreSQL database but I'd be interested to know if any is able to do this.

CREATE VIEW w AS SELECT name FROM People UNION ALL SELECT name FROM dogs could be used — Lukasz Szozda
– Lukasz Szozda, Commented Nov 28, 2020 at 16:13

Mureinik · Accepted Answer · 2020-11-28 16:16:24Z

1

You could use the union all set operator to unify results from both tables:

CREATE VIEW all_names AS 
SELECT name FROM people
UNION ALL
SELECT name FROM dogs

answered Nov 28, 2020 at 16:16

Mureinik

316k54 gold badges402 silver badges406 bronze badges

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

Collectives™ on Stack Overflow

Can a database view be created from multiple selects? For instance row 1 is entirely from 1 table and row 2 is from another

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