This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:statements:join:home [2009/12/04 22:14] tdo |
dev:sql:statements:join:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 2: | Line 2: | ||
<html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
====== Omnidex SQL: JOIN ====== | ====== Omnidex SQL: JOIN ====== | ||
+ | {{page>:sql_bar&nofooter&noeditbtn}} | ||
+ | |||
===== Description ===== | ===== Description ===== | ||
The JOIN statement can be used in conjunction with the Omnidex Query Language QUALIFY command, to allow qualifications across tables. A JOIN statement follows one or more QUALIFY statements against the from_table, and precedes one or more QUALIFY statements against the to_table. | The JOIN statement can be used in conjunction with the Omnidex Query Language QUALIFY command, to allow qualifications across tables. A JOIN statement follows one or more QUALIFY statements against the from_table, and precedes one or more QUALIFY statements against the to_table. | ||
Line 15: | Line 17: | ||
===== Discussion ===== | ===== Discussion ===== | ||
- | == [ FROM ] from_table == | + | == [ FROM ] from_table_spec == |
- | Required. The FROM keyword is supported for visual clarity, but is optional. The from_table parameter is the table in the previous QUALIFY statement. | + | Required. The FROM keyword is supported for visual clarity, but is optional. The //from_table_spec// is the table specified in the previous QUALIFY statement. |
- | == USING from_join_col == | + | == USING from_join_column_spec == |
- | Required - The USING keyword is required. The from_join_col parameter is the link column in the from_table that will be joined to the link column in the to_table. | + | Required - The USING keyword is required. The //from_join_column_spec// is the link column in the //from_table_spec// that will be joined to the link column in the //to_table_spec//. |
- | == TO to_table == | + | == TO to_table_spec == |
- | Required. The TO keyword is required. The to_table parameter is the table that will be joined with the table in the previous QUALIFY statement. | + | Required. The TO keyword is required. The //to_table_spec// is the table that will be joined with the table in the previous QUALIFY statement. |
- | == [ USING to_join_col ] == | + | == [ USING to_join_column_spec ] == |
- | Required - The USING keyword is required. The to_join_col parameter is the link column in the to_table that will be joined to the link column in the from_table. | + | Required - The USING keyword is required. The //to_join_column_spec// parameter is the link column in the to_table that will be joined to the link column in the from_table. |
== [ OWNED BY table_name ] == | == [ OWNED BY table_name ] == |