[SQL-CVS] r731 - trunk/SQLObject/docs

[<sub...@co...>]

Author: ianb
Date: 2005-04-20 21:07:43 +0000 (Wed, 20 Apr 2005)
New Revision: 731

Modified:
   trunk/SQLObject/docs/SQLObjectJoins.txt
Log:
Minor reformatting

Modified: trunk/SQLObject/docs/SQLObjectJoins.txt
===================================================================
--- trunk/SQLObject/docs/SQLObjectJoins.txt	2005-04-20 12:00:32 UTC (rev 730)
+++ trunk/SQLObject/docs/SQLObjectJoins.txt	2005-04-20 21:07:43 UTC (rev 731)
@@ -4,25 +4,32 @@
 First look in the FAQ_, question "How can I do a LEFT JOIN?"
 
 Still here? Well. To perform a JOIN use one of the JOIN helpers from
-sqlobject.sqlbuilder. Pass an instance of the helper to .select() method.
-For example::
+sqlobject.sqlbuilder. Pass an instance of the helper to .select()
+method.  For example::
 
     from sqlobject.sqlbuilder import LEFTJOINOn
-    MyTable.select(join=LEFTJOINOn(Table1, Table2, Table1.q.name == Table2.q.value))
+    MyTable.select(
+        join=LEFTJOINOn(Table1, Table2, 
+                        Table1.q.name == Table2.q.value))
 
 will generate the query::
 
-    SELECT * FROM my_table, table1 LEFT JOIN table2 ON table1.name = table2.value;
+    SELECT * FROM my_table, table1 
+    LEFT JOIN table2 ON table1.name = table2.value;
 
-.. _FAQ: FAQ.html
+.. _FAQ: FAQ.html#how-can-i-do-a-left-join
 
-If you want to join with the primary table - leave the first table None::
+If you want to join with the primary table - leave the first table
+None::
 
-    MyTable.select(join=LEFTJOINOn(None, Table1, MyTable.q.name == Table1.q.value))
+    MyTable.select(
+        join=LEFTJOINOn(None, Table1, 
+                        MyTable.q.name == Table1.q.value))
 
 will generate the query::
 
-    SELECT * FROM my_table LEFT JOIN table2 ON my_table.name = table1.value;
+    SELECT * FROM my_table 
+    LEFT JOIN table2 ON my_table.name = table1.value;
 
 The join argument for .select() can be a JOIN() or a list/tuples of
 JOIN()s.
@@ -39,13 +46,14 @@
 
 will generate the query::
 
-    SELECT * FROM my_table, my_table AS my_table_alias WHERE my_table.name = my_table_alias.value;
+    SELECT * FROM my_table, my_table AS my_table_alias 
+    WHERE my_table.name = my_table_alias.value;
 
 Can I use LEFTJOIN() with aliases?
 ----------------------------------
 
-Sure! That's a situation the JOINs an aliases were primary developed for.
-Code::
+Sure! That's a situation the JOINs and aliases were primary developed
+for.  Code::
 
     from sqlobject.sqlbuilder import LEFTJOINOn, Alias
     alias = Alias(OtherTable, "other_table_alias")