On Tue, Jan 03, 2006 at 02:15:25PM -0800, Dan Tenenbaum wrote: > I want to show all rows where the first part of the WHERE clause is true, > regardless of whether the provider_key is in the login_provider table (in > that cause, I want to show 0 in that column).
Sounds like you're looking for an outer join. http://www.postgresql.org/docs/8.1/interactive/tutorial-join.html http://www.postgresql.org/docs/8.1/interactive/queries-table-expressions.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
