[Please copy the mailing list on replies so others can participate in and learn from the discussion.]
On Fri, Jul 28, 2006 at 09:54:42AM -0500, Steven Adams wrote: > I wanted the row to show whether or not there was a matching row in the > other table, but I wanted to return exactly 1 row. As Tom Lane already pointed out, you're probably needing a WHERE clause. Does this do what you want? SELECT ia.name, iac.internal FROM information_assets AS ia LEFT OUTER JOIN information_asset_categories AS iac ON ia.category_id = iac.id WHERE ia.id = 21; -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org