Getting Started with SQL and Databases: Managing and Manipulating Data with SQL by Mark Simon

Author:Mark Simon
Language: eng
Format: epub
ISBN: 9781484294932
Publisher: Apress

How a Join Works

In order to understand joins, you will need to understand some basic concepts of how tables are related. Of course, SQL doesn’t really require you to understand what’s going on, but joins can get very tricky if you don’t.

In Chapter 2, some of the central points in designing a database are as follows:A table contains data on a single type of object. So, for example, a paintings table has no artists details, and a books table has no authors details.

Multiple rows should not have the same data. So, for example, two paintings by the same artist should not both have the artist’s name, and two books by the same author should not have the same author’s name.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.