Post reply

RE:

  • February 6, 2006 at 8:50 pm

    #67138

    Hi,

    This is a great article.  Is there any way to reduce the output that returns 4 rows, to only report the two customers, Andy and Delaney, that did not place an order in October?  Either I'm missing some dead obvious, or it's not possible to do this with a LEFT OUTER JOIN.

    Thanks,

    Ian

  • February 7, 2006 at 7:09 am

    #619246

    Ian,

    You can reduce this by limiting the results again to look for a NULL in the left outer table.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply