|
From: <sub...@co...> - 2007-08-21 07:39:48
|
Author: phd
Date: 2007-08-21 01:39:42 -0600 (Tue, 21 Aug 2007)
New Revision: 2879
Modified:
SQLObject/docs/SQLObject.txt
Log:
Minor documentation update - MyTable.select() always meant
SELECT my_table.*, not SELECT *, even for joins.
Modified: SQLObject/docs/SQLObject.txt
===================================================================
--- SQLObject/docs/SQLObject.txt 2007-08-21 07:39:20 UTC (rev 2878)
+++ SQLObject/docs/SQLObject.txt 2007-08-21 07:39:42 UTC (rev 2879)
@@ -1909,7 +1909,7 @@
will generate the query::
- SELECT * FROM my_table, table1
+ SELECT my_table.* FROM my_table, table1
LEFT JOIN table2 ON table1.name = table2.value;
.. _FAQ: FAQ.html#how-can-i-do-a-left-join
@@ -1923,7 +1923,7 @@
will generate the query::
- SELECT * FROM my_table
+ SELECT my_table.* FROM my_table
LEFT JOIN table2 ON my_table.name = table1.value;
The join argument for .select() can be a JOIN() or a sequence (list/tuple)
@@ -1948,7 +1948,7 @@
will generate the query::
- SELECT * FROM my_table, my_table AS my_table_alias
+ SELECT my_table.* FROM my_table, my_table AS my_table_alias
WHERE my_table.name = my_table_alias.value;
Can I use a JOIN() with aliases?
@@ -1964,7 +1964,7 @@
will result in the query::
- SELECT * FROM other_table,
+ SELECT my_table.* FROM other_table,
my_table LEFT JOIN other_table AS other_table_alias
WHERE my_table.name == other_table.value AND
my_table.col1 = other_table_alias.col2.
|