vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes: > 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. IN works fine on multiple columns: (foo, bar, baz) IN (SELECT x, y, z FROM ...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |