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/