Author: phd
Date: 2007-08-21 01:38:43 -0600 (Tue, 21 Aug 2007)
New Revision: 2876
Modified:
SQLObject/branches/0.7/docs/SQLObject.txt
Log:
Minor documentation update - MyTable.select() always meant
SELECT my_table.*, not SELECT *, even for joins.
Modified: SQLObject/branches/0.7/docs/SQLObject.txt
===================================================================
--- SQLObject/branches/0.7/docs/SQLObject.txt 2007-08-21 07:31:44 UTC (rev 2875)
+++ SQLObject/branches/0.7/docs/SQLObject.txt 2007-08-21 07:38:43 UTC (rev 2876)
@@ -1737,7 +1737,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
@@ -1751,7 +1751,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)
@@ -1776,7 +1776,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?
@@ -1792,7 +1792,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.
|