Re: SQL help needed

[John English]

On 27/11/2016 18:29, Rick Hillegas wrote:
Hi John,
The outer join is the typical SQL approach to computing the difference
between two relations:

  select * from x left join y
  on x.a = y.a and x.b = y.b
  where y.a is null;

Ah, excellent: very clever. This looks like the perfect solution! (And 
it also runs in a few seconds rather than many many minutes.)

--
John English