Data Management

Introduction to Basic SQL, Part 2 - Joins

In my last article, I introduced you to some basic SQL commands and some new concepts, mainly the data dictionary. Today we will get a little further into basic SQL by joining two tables in a single select statement.

In the last article, I glossed over the difference between a view and a table, so I would like to clarify that here. A table is the basic storage for your data in the database. A table is made up of rows and columns. A view is a stored query that appears to be a table. For example:

Create view abc as select * from all_tables;

Editor's Picks