OOPS! the ON AND was a typo. Sorry! Should have been just ON. I am
puzzled why it worked but I am glad it did.
That's what I get for too much cut-and-paste at the end of the day. I
apologize to everyone!
What actually made it work was not the ON AND (yuck!) but the LEFT JOIN.
What you were tr
Richard Reina <[EMAIL PROTECTED]> wrote on 01/07/2005 03:31:26 PM:
> I am having trouble with a query that gives me
> activities that have not been "written up" but if
> these activities are a party they whould only appear
> in the query if they have been held, hence date will
> not='-00-00'
>
I am having trouble with a query that gives me
activities that have not been "written up" but if
these activities are a party they whould only appear
in the query if they have been held, hence date will
not='-00-00'
If I write the query as so, no non-party activities
will show up because the f