PB with NULL "value" in a select statement ...

Hi,

My table T (with c1 and c2 columns) is filled like this :

c1 c2

AA XX
BB XX
CC YY
DD NULL
EE ZZ

I execute the following request : SELECT c1,c2 from T where c2 != 'ZZ' and I obtain 3 lines (2 with 'XX' and 1 with 'YY') How can I do to simply obtain 4 lines : 2 with 'XX', 1 with 'YY' and 1 with NULL ?...

Thanks

David Received on Tue Jul 03 2001 - 18:42:18 CEST