SQL View with Data from two tables
- by Alex
Hello! I can't seem to crack this - I have two tables (Persons and Companies), and I'm trying to create a view that:
1) shows all persons
2) also returns companies by themselves once, regardless of how many persons are related to it
3) orders by name across both tables
To clarify, some sample data:
(Table: Companies)
Id Name
1 Banana
2 …