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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
