SELECT CI.NAME
FROM COUNTRY CO
JOIN CITY CI ON CI.CountryCode = CO.CODE
WHERE CO.CONTINENT = 'Africa';
SELECT
select_list
FROM t1
INNER JOIN t2 ON join_condition1
INNER JOIN t3 ON join_condition2
...;
Code Example |
---|
Sql :: order of sql |
Sql :: query inner join |
Sql :: tsql generate rows |
Sql :: sql server whoami |
Sql :: insufficient privileges while creating view in sql oracle |
Sql :: sqlalchemy query sql compiled |
Sql :: split string and copy last element postgresql |
Sql :: one to one and one to many relationship |
Sql :: oracle INTERVAL DAY to second to number |
Sql :: insert json file to mssql |
Sql :: join vs inner join |
Sql :: index postgres |
Sql :: json_modify sql server |
Sql :: oracle logfile switch |
Sql :: sql server inner join |
Sql :: MySQL OR |
Sql :: mysql copy row with new id |
Sql :: sql default |
Sql :: show broken table mysql |
Sql :: drop unique |
Sql :: Insufficient memory to excute the sql query |
Sql :: sql day from datetime |
Sql :: clustered-nonclustered indexes(constraints) |
Sql :: function in sql |
Sql :: how to start postgresql laravel |
Sql :: sql constraints |
Sql :: float vs decimal sql |
Sql :: How do I install microsoft SQL on my Mac? |
Sql :: where keyword sql |
Sql :: sql limit results |