Duplicates
Digression: Metadata of query results
Conclusion
- Tables explicitly created have a lot of metadata.
- This includes PK and FK declarations.
- Very little metadata carries through SQL queries.
- In particular, PK and uniqueness constraints do not.
- Which is why query results may have duplicates.
|