Groups > comp.lang.java.databases > #680

joining

Path	csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	Roedy Green <see_website@mindprod.com.invalid>
Newsgroups	comp.lang.java.databases
Subject	joining
Date	Fri, 08 Aug 2014 05:04:55 -0700
Organization	Canadian Mind Products
Lines	21
Message-ID	<jve9u9d3vao1hvitvdmslkeec7sn7duv4o@4ax.com> (permalink)
Reply-To	Roedy Green <see_website@mindprod.com.invalid>
NNTP-Posting-Host	K2Qzzs3EAqXk5RLzfhxcSw.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	ForteAgent/7.20.32.1218
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.lang.java.databases:680

Show key headers only | View raw

I have a very simple application.
I have records for quotations and records for authors.
Each quotation has as most one author, but each author can have many
quotations.

I look up the quotation, then I want to find the author record.

What I do now is have a unique integer id in the author record and I
look it up separately.

I suspect it might be faster/better to get SQL to join the records for
me and present me with one unified record. I don't want collections,
just a single author-quotation record.

Is that a better approach and if so, what does a query look like given
each record has a unique integer key?
-- 
Roedy Green Canadian Mind Products http://mindprod.com
The art of strongly-typed language design is largely arranging 
that errors are automatically detected as soon as possible
in the compose, compile, run cycle.

Back to comp.lang.java.databases | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-08 05:04 -0700
  Re: joining Lothar Kimmeringer <news200709@kimmeringer.de> - 2014-08-08 15:54 +0200
    Re: joining Chris Riesbeck <Chris.Riesbeck@gmail.com> - 2014-08-08 11:55 -0500
      Re: joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-08 19:19 -0700
        Re: joining Silvio <silvio@internet.com> - 2014-08-09 07:06 +0200
          Re: joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-09 02:45 -0700
            Re: joining Silvio <silvio@internet.com> - 2014-08-09 12:16 +0200
              Re: joining Chris Riesbeck <Chris.Riesbeck@gmail.com> - 2014-08-11 12:23 -0500

csiph-web