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 |
6 of 13 |