On Tue, Feb 28, 2006 at 11:55:32AM -0600, Kevin Grittner wrote: >> Also, EXISTS works in situations where >> you need to compare on multiple columns, so it is useful in many >> situations where EXISTS or MIN/MAX techniques just don't work. > Sorry. That should have read: > > EXISTS works in situations where > you need to compare on multiple columns, so it is useful in many > situations where IN or MIN/MAX techniques just don't work. Can't you just do WHERE (foo,bar) IN ( SELECT baz,quux FROM table )? I'm quite sure I've done that a number of times. /* Steinar */ -- Homepage: http://www.sesse.net/
