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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings