This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:statements:join:home [2009/12/04 22:14] tdo created |
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 ] == | ||
| Line 37: | Line 39: | ||
| ===== Examples ===== | ===== Examples ===== | ||
| The following example qualifies all orders in the Orders table that were canceled. It then joins the qualified orders to the products table which are further refined with another qualify. Finally, the qualified product names are retrieved with a select statement using the odxid WITH option. | The following example qualifies all orders in the Orders table that were canceled. It then joins the qualified orders to the products table which are further refined with another qualify. Finally, the qualified product names are retrieved with a select statement using the odxid WITH option. | ||
| - | |||
| - | ==== Simple ==== | ||
| <code> | <code> | ||