combinatorial solution set
yields every combination that matches query:
|
| ||||||||||||||||||||
SELECT Friend.name,Address.street
FROM Friend,Address
WHERE Friend.id=Address.id
| query results | |
|---|---|
| name | street |
| Dick | 218 12th Street West |
| Jane | 6219 6th Avenue |
| Dick | 123 Elmstraas |
7 of 15 |