http://sqlzoo.net/w/index.php?title=Special:RecentChangesLinked/Self_join&feed=atom&target=Self_join 2013-05-21T11:23:44Z Related changes MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=Using_a_self_join&diff=13167&oldid=1701 2013-05-16T13:07:41Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 13:07, 16 May 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 22:</td> <td colspan="2" class="diff-lineno">Line 22:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &lt;p&gt;This is a large table with over 11000 entries. An extract is</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &lt;p&gt;This is a large table with over 11000 entries. An extract is</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &#160; shown below. There are 121 entries the LRT 1 service alone.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &#160; shown below. There are 121 entries <ins class="diffchange diffchange-inline">for </ins>the LRT 1 service alone.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; There are 11 stops on the number 1. It is a circular route -</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; There are 11 stops on the number 1. It is a circular route -</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; the first and last stops are identical.&lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; the first and last stops are identical.&lt;/p&gt;</div></td></tr> </table>

Kc9400