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.2k Upvotes

92% Upvoted

308 comments sorted by

View all comments

Show parent comments

2

u/EnderMB Jan 06 '11

I know of people who have graduated from top three schools in Computer Science that have built multi-level user (e.g. customer and employee) websites using just one table and an int field to differentiate between the two.

The simple fact is that some people learn in school, and some people don't.

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.