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 ] == | ||