<p>In <a href="https://github.com/dbsrgits/dbix-class/pull/100#discussion_r59412818">lib/DBIx/Class/Manual/Joining.pod</a>:</p>
<pre style='color:#555'>>
> -When you wish to extract information about a particular CD and all
> -its tracks, You can either fetch the CD row, then make another query
> -to fetch the tracks, or you can use a join. Compare:
> +To retrieve information about a particular CD and all its tracks, either
> +fetch the CD row, then make another query to fetch the tracks, or use a
> +join. Compare:
</pre>
<div class="email-quoted-reply">On Mon, Apr 11, 2016 at 03:29:08PM -0700, Peter Rabbitson wrote:
I think this needs to be expanded a little - as `join` on its own
won't fetch anything extra. Perhaps `L<join and
select|DBIx::Class::Resultset/prefetch>` the extra data.</div>
<div class="email-fragment">Good point. I'll work on that.</div>
<div class="email-quoted-reply"> Also towards the end of this section there is a link to a reference
manual on SQL-side join syntax, not sure if this is the best
resource... Thoughts?</div>
<div class="email-fragment"><a href="https://en.wikipedia.org/wiki/Join_%28SQL%29">https://en.wikipedia.org/wiki/Join_%28SQL%29</a> provides a more database
agnostic reference and
<a href="https://blog.codinghorror.com/a-visual-explanation-of-sql-joins/">https://blog.codinghorror.com/a-visual-explanation-of-sql-joins/</a>
provides a popular visual summary. How about I link to those instead?
Tom</div>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly or <a href="https://github.com/dbsrgits/dbix-class/pull/100/files/fcdc83ff88abb7af881d1afcf4e04ea78f57dbb5..03dfab976209fe0e82beea31cf88417bc4eb4e09#r59412818">view it on GitHub</a><img alt="" height="1" src="https://github.com/notifications/beacon/AASeAiNFK9XZS-hKDrHaBfJ7Lf9Jyrr-ks5p29BVgaJpZM4IE3uw.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/dbsrgits/dbix-class/pull/100/files/fcdc83ff88abb7af881d1afcf4e04ea78f57dbb5..03dfab976209fe0e82beea31cf88417bc4eb4e09#r59412818"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>