SQL forcing all results into a flat table is one of its biggest design flaws. It creates tremendous data duplication.