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 [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 37: | Line 37: | ||
| ===== 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> | ||