On Sat, Jul 22, 2006 at 12:47:42PM -0700, [EMAIL PROTECTED] wrote: > I would like to join table user and userwork, where if a user has a > work, I list it. If he does not, I give it some default value "no work"
You could use an outer join and COALESCE. http://www.postgresql.org/docs/8.1/interactive/tutorial-join.html http://www.postgresql.org/docs/8.1/interactive/queries-table-expressions.html#QUERIES-JOIN http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html#AEN12639 Example: SELECT u.id, u.name, u.address, COALESCE(uw.work, 'no work') AS work FROM "user" AS u LEFT OUTER JOIN userwork AS uw ON uw.userid = u.id; -- 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
