Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder7.xlned.com!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!news.online.de!not-for-mail
From: Lothar Kimmeringer <news200709@kimmeringer.de>
Newsgroups: comp.lang.java.databases
Subject: Re: joining
Date: Fri, 8 Aug 2014 15:54:11 +0200
Organization: Organization?! Only chaos here!
Lines: 37
Message-ID: <q565h9mt8b3f$.dlg@kimmeringer.de>
References: <jve9u9d3vao1hvitvdmslkeec7sn7duv4o@4ax.com>
Reply-To: news@kimmeringer.de
NNTP-Posting-Host: mnch-5d86b30b.pool.mediaways.net
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Trace: online.de 1407506050 28401 93.134.179.11 (8 Aug 2014 13:54:10 GMT)
X-Complaints-To: abuse@einsundeins.com
NNTP-Posting-Date: Fri, 8 Aug 2014 13:54:10 +0000 (UTC)
User-Agent: 40tude_Dialog/2.0.15.1de
Xref: csiph.com comp.lang.java.databases:681

Roedy Green wrote:

> I suspect it might be faster/better to get SQL to join the records for
> me and present me with one unified record.

If you mean resultset when speaking of record, it is.

> Is that a better approach and if so, what does a query look like given
> each record has a unique integer key?

Not sure, where the java-related question is, but the statement
would look like this:

Table authors:

id int
name varchar
...

Table quotes:
id int
id_author int
quote text
...


select a.name, b.quote from authors a, quotes b
where a.id = b.id_author


Cheers, Lothar
-- 
Lothar Kimmeringer                E-Mail: spamfang@kimmeringer.de
               PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)

Always remember: The answer is forty-two, there can only be wrong
                 questions!