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

joining

From	Roedy Green <see_website@mindprod.com.invalid>
Newsgroups	comp.lang.java.databases
Subject	joining
Date	2014-08-08 05:04 -0700
Organization	Canadian Mind Products
Message-ID	<jve9u9d3vao1hvitvdmslkeec7sn7duv4o@4ax.com> (permalink)

Show all headers | 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

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