[ADMIN] Outer joins

Hello, is there a possibility to use "outer joins" (left outer join) with pgsql? I have a problem joining two tables: TablePerson TableTitle --- -- pk_idperson int primary key

Re: [ADMIN] Outer joins

Try the following: SELECT name,firstname,title FROM TablePerson,TableTitle WHERE TablePerson.fk_idtitle = TableTitle.pk_idtitle UNION SELECT name,firstname,''::varchar(10) FROM TablePerson WHERE fk_idtitle IS NULL; Guido Weber On Mon, 2 Nov 1998 [EMAIL PROTECTED] wrote: > Hello, > > i