Tables used in my JOIN tutorial series
In order to make the concept of SQL join easy to understand I have created and populated two very simple tables.
Table 1: EMP this is a very simple table which consists of 3 columns emp id, emp name and emp salary where column emp id is the primary key.
The query to create this table is:
CREATE TABLE emp
  (
    emp_id    NUMBER(2) CONSTRAINT emp_col1_pk PRIMARY KEY,
    emp_name VARCHAR2(20),
    emp_salary NUMBER(5)
  );
Table 2: The second table is DEPT this table also consists of 3 columns dept id, dept name and emp id. Column dept id is the primary key here and column emp id is the foreign key reference from the emp table.
The query to create this table is:
CREATE TABLE dept
  (
    dept_id    NUMBER(2) CONSTRAINT emp_col1_pk PRIMARY KEY,
    dept_name VARCHAR2(20),
    emp_id CONSTRAINT dept_col3_fk REFERENCES emp(emp_id)
  );
Data in the table.
You can insert whatever data you want in these tables but for the demonstration of the SQL join I have inserted 5 rows in each table.
I am providing you the SQL script where you can find the query for Table Creation and Data insertion.
