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 [2010/07/04 04:13] tdo |
dev:sql:statements:join:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 17: | 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 ] == | ||