WEEK 5 and 6

• SQL Join statement - combines data or rows from two or more tables based on a common field between them
• Join Keyword – it merges two or more tables and creates a temporary image of the merged table.
• Inner Join or Equi Join – is the simplest join where all rows from the intended tables are catched together.
• Cross Join – also known as Cartesian Join.