Results of 1 - 1 of about 1 for iata (0.001 sec.)
- FROM and JOIN Clauses 9414
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...nally incomplete, i.e., they do not have a matching pair in the other table. CREATE TABLE city_airport (city_name VARCHAR, iata VARCHAR); CREATE TABLE airport_names (iata VARCHAR, airport_name VARCHAR); INSERT INTO city_airport VALUES ('Amsterdam', '...hiphol'), ('RTM', 'Rotterdam The Hague Airport'), ('MST', 'Maastricht Aachen Airport'); To join the tables on their shared IATA attributes, run: SELECT * FROM city_airport NATURAL JOIN airport_names; This produces the following result: city_name iata...name Amsterdam AMS Amsterdam Airport Schiphol Rotterdam RTM Rotterdam The Hague Airport Note that only rows where the same iata attribute was present in both tables were included in the result. We can also express this query using the vanilla JOIN cl... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work