Re: where with NULL values are not selected

Am Freitag, 8. Juli 2005 12:08 schrieb Düster Horst:
> table1.column and table2.column may have NULL values. The problem is that
> these columns where not selected. Does there exists any solution to
> select/join the NULL value colums also.

Read up on outer joins.  In your case, try this:

select table1.column from table1 full outer join table2 on
(table1.column=table2.column);

--
Peter Eisentraut
http://developer.postgresql.org/~petere/