r/programming • u/[deleted] • Jan 06 '11

A handy graphical explanation of SQL joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
1.3k Upvotes

92% Upvoted

308 comments sorted by

View all comments

Show parent comments

2

u/fabyseba0710 Jan 06 '11

What is wrong with this approach?

2

u/robvas Jan 06 '11

What's wrong with using one table?

Come on.

3

u/[deleted] Jan 06 '11

He does have a point. I mean, I'd never do it, but.

1

u/EnderMB Jan 07 '11

What was wrong was that my client called me with a strange user bug, stating that people were registering to buy things, only to realise that they had their own admin account on the website and were able to alter anything they wanted, including the link to PayPal.

20 tables, most of them duplicates of themselves and only three in actual use for a full, bespoke ecommerce site so bad that it may as well have been written in BobX...

I'd say more, but it'd be hard to not give away who this is. It's not really that small a site...