Contribute to liubovkyry/SQL development by creating an account on GitHub.

-- select name, region, and gdp_percapita SELECT name, region, gdp_percapita -- countries (alias c) on the left FROM countries AS c -- join with economies (alias e) LEFT JOIN economies AS e -- match ...

An inner join returns a result table for all the rows in a table that have one or more matching rows in the other table (s), as specified by the sql-expression.

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.

INNER JOIN (Used to exemplify equi-join) An equi-join is one type of INNER JOIN that can be applied using SQL. Equi-joins will be used with SELECT statements to select data from more than one table.