--- James Orr <james@lrgmail.com> wrote:
> I think he might be talking about mine. The region
> values will not be
> duplicated, the WHERE clause prevents it.
If you are saying that I didn't read the original
query closely enough, you're probably right.
Unfortunately I deleted the original message, so I
can't check that.
> I kind of prefer my own query aesthetically, is it
> as efficient internally?
Someone more knowledgable will have to answer that:
though I would guess that working with three joined
tables would slow things down somewhat.
>
> - James
>
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com