Re: SQL question from an absolute SQL newbie

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

On 8/31/2011 3:08 AM, Morgan, Paul wrote:
> Select *
>    from TCKTHIST a
>   where a.POST_DATE = dec( replace( char( current_date - 1 day, iso ), '-' , '' ), 8 ) // stolen from chuck's answer
>     and not exists( Select *
>                       from NEWTCKTS b
>                      where a.TICKET#   = b.TICKET#
>                        and a.CUSTOMER# = b.CUSTOMER#
>                        and a.TRAN_DATE = b.TRAN_DATE )
>
> You could do a funky join between TCKTHIST and NEWTCKTS instead of the exists( test if performance is a problem.

What's funky about an exception join?  Especially since the fields have 
the same name, so you can use the USING clause (although the USING 
clause has other side effects you should be aware of).

Joe