⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
advanced help
per page, with , order by , clip by
Results of 1 - 1 of about 1 for Rotterdam (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 ... ; CREATE TABLE airport_names (iata VARCHAR, airport_name VARCHAR); INSERT INTO city_airport VALUES ('Amsterdam', 'AMS'), ('Rotterdam', 'RTM'), ('Eindhoven', 'EIN'), ('Groningen', 'GRQ'); INSERT INTO airport_names VALUES ('AMS', 'Amsterdam Airport Schiphol ... '), ('RTM', 'Rotterdam The Hague Airport'), ('MST', 'Maastricht Aachen Airport'); To join the tables on their shared IATA attributes, run: SELECT ... IN airport_names; This produces the following result: city_name iata airport_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 ...
https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work