Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: the opposite of join?

    For the same result you could try this:

    select *

    from tableA

    where not exists (Select Field1

                           from  TableB

                           where Field1=TableA.Field1)

Viewing post 1 (of 1 total)