Very dumb question, but bear with me, I am learning and am interested in the principles behind.
So: I have a
users table and a
pages table. In this case, 1 user and 4 pages. If I join the two tables, I get four times the user data, along with the pages data. The result is little legible, when I see a result stream like this I think wtf?
I know 'databases are just made this way'. I'd like to learn some context and meaning.