Re: Frustrated Join?

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

Thanks for the response, Rick.

Any references? I tried Googling for 'Frustrated Join' and 'Frustrated Outer
Join' and all I came up with were requests for people who were frustrated by
something or other to join some advocacy group <g>. Not the same thing.

And, of course, references to some of Allen Browne's post to these news
groups, which were the source of my question.

Once again, thanks!
--
Chaim


"Rick Brandt" wrote:

> Chaim wrote:
> > I've seen this description of a join used several times in recent
> > posts. Anyone care to give either a definition or references?
>
> It's used when you want to see all the records in one table that do not have
> matches in another table.
>
> SELECT *
> FROM TableA Left Outer Join TableB
> On TableA.ID = TableB.ID
> WHERE TableB.ID Is Null
>
> The Left Outer Join would normally indicate "give me all records from
> TableA" but the WHERE clause "frustrates" that by limiting the results to
> those rows where no matching record exists in TableB.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>
.

Relevant Pages

  • Re: JDK implementation of inner classes doesnt match Java Language Specification
    ... every Inner object has a reference to its parent ... or is it static per "instance" of Outer? ... referenced by the same set of references. ...
    (comp.lang.java.programmer)
  • Re: static inner classes
    ... > references to the outer class member attributes, ... > outer class primitive attributes. ... > class that copies the references you cannot achieve this. ... Assume we have a top-level class named Top that contains an inner class ...
    (comp.lang.java.programmer)
  • Re: Intersection Referene Operator
    ... necessary to use the *outer* columns and rows as references. ... the intersection operator is much ... simpler than the first convoluted IF OFFSET MATCH formula. ...
    (microsoft.public.excel)
  • Re: How to access nested parent?
    ... This does not imply that an instance of Outer contains an instance of ... All objects are peers and exist as areas of memory on the heap or ... Some objects hold references to other objects, ...
    (microsoft.public.dotnet.languages.csharp)
  • Frustrated Join?
    ... Anyone care to give either a definition or references? ... Chaim ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)