Re: How To Avoid Cartesian Products?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks, George!

I'll be taking your first suggestion, by process of elimination. The second
seems impractical given the number of records in each table, and the third is
something I will consider for the next time I refactor the database.

I will also be looking for ways to include the fire and auto queries you
mentioned as subqueries, rather than independently saved queries. I find it
clutters my database to have all these separate saved queries lying around.

George Nicholson wrote:
Several approaches. Here are some:

Create 2 queries (Fire and Auto) to give you a one-record monthly sum per
agent. Left Join those queries to your Agents table.

Alternatively, Create a Union Query that combines the Auto and Fire Info
(adding a Policy Type field), and join that to Agents.

Alternatively, Combine Auto and Fire into one NB table (which they probably
should have been from the start). Since you say they contain the same
fields, you probably would only need to add one additional field for
PolicyType (i.e., Fire, Auto). On a similar note, I question whether NB
really belongs in a separate table from Existing business. NB/Existing
sounds more like an data Attribute to me than data of a different type.

Hello! This is my first post on to Access Monster. I have a specific
question with general implications. I've simplified it, since the real
[quoted text clipped - 34 lines]
The question: Is there an easy way around this? I've done so by using
subqueries for now, but they are unbearably slow.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200803/1

.

Relevant Pages

  • Re: How To Avoid Cartesian Products?
    ... Left Join those queries to your Agents table. ... Create a Union Query that combines the Auto and Fire Info ...
    (microsoft.public.access.queries)
  • Re: [Book Review] AK-47 : The Weapon That Changed The Face of war
    ... # # # denies any of his gun was copied or inspired by the German gun. ... or semi-auto and full auto/selective fire. ... devestating condemnation of the international arms trade. ... made to fire full or semi auto selectively. ...
    (rec.guns)
  • Re: A red tide in the affairs of men.
    ... Positions {Safe, Fire, Auto} all exist, but Auto is not selectable on this model due to the mods. ... The field expedient conversion to full-auto involved something like stripping the action, pulling the selector lever and replacing it in the receiver rotated 180 degrees. ...
    (alt.sysadmin.recovery)
  • Re: Tight Formation
    ... choice of semi-auto (one shot per trigger pull) or full auto ... now there's a three-round burst setting. ... A trained man can easily fire 2 or 3 round bursts ...
    (rec.aviation.military)
  • Getting first and last entities in collection in EJB3
    ... I have a one-to-many bidirectional relation between two entities A and ... of a way to do this in a single query. ... I fire two queries each to get the first and last entities B in the B ...
    (comp.lang.java.programmer)