summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-04-24 18:51:21 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-04-24 18:51:21 +0000
commit898034c214dbae0c4f11dbd1301d26147dee42ea (patch)
treea366f24687b094245ea1ecce703043288cbd426f
parent088460f22200023070896211c649c59111969c98 (diff)
downloadsqlalchemy-898034c214dbae0c4f11dbd1301d26147dee42ea.tar.gz
added an order_by
-rw-r--r--doc/build/content/tutorial.txt4
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/build/content/tutorial.txt b/doc/build/content/tutorial.txt
index e8cb2e307..63c28860d 100644
--- a/doc/build/content/tutorial.txt
+++ b/doc/build/content/tutorial.txt
@@ -263,9 +263,9 @@ Next, lets put a few rows in:
With two related tables, we can now construct a join amongst them using the `join` method:
{python}
- >>> r = users_table.join(email_addresses_table).select().execute()
+ >>> r = users_table.join(email_addresses_table).select(order_by=users_table.c.user_id).execute()
SELECT users.user_id, users.user_name, users.password, email_addresses.address_id, email_addresses.email_address, email_addresses.user_id
- FROM users JOIN email_addresses ON users.user_id = email_addresses.user_id
+ FROM users JOIN email_addresses ON users.user_id = email_addresses.user_id ORDER BY users.user_id
[]
>>> print [row for row in r]
[(1, u'Mary', u'secure', 2, u'mary@mary.com', 1), (2, u'Tom', None, 1, u'tom@tom.com', 2)]