Category Archives: sql

SQL – Joins Table of content The SQL Join Clause The SQL Join clause is used to combine data from two or more tables in a database. When the related data is stored across multiple tables, joins help you to retrieve records combining the fields from these tables using their foreign keys. The part of […]

SQL – Inner Join Table of content An SQL Join clause is used to combine multiple related tables in a database, based on common fields/columns. There are two major types of joins: Inner Join and Outer Join. Other joins like Left Join, Right Join, Full Join etc. Are just subtypes of these two major joins. […]

SQL – Alias Syntax Table of content You can rename a table or a column in a database temporarily by giving them another pseudo name. This pseudo name is known as Alias. The use of aliases is to address a specific table or a column in an SQL statement without changing their original name in […]