Re: Query Help - Duplicate Records
Joins are absolutely fundamental to relational databases. Designing databases isn't like using a word processor or spreadhseet. There's a crucial theory, a set of basic rules, you absolutely must know. Stop designing long enough to study up on relational dbs and sql.
...tblname as name... is an alias.
> we will be serving thousands of customers, each with their own table
Probably also a design error. ya think Visa keeps every ID and associated data in its own table!? Have you ever pulled up someone else's purchases when browsing your credit card statement?
Putting data in a separate table is no less error-prone than storing data from multiple customers in one table according to well-designed key, but it's vastly less efficient.
Subject
Written By
Posted
November 20, 2016 04:11AM
November 20, 2016 10:34AM
November 22, 2016 03:40AM
Re: Query Help - Duplicate Records
November 22, 2016 02:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.