posted 20 years ago
i would like to select some columns from different tables, but from within 15 of these , sometimes 7 of them might be empty.
But I would like to set these 'null' values with either empty or null. How can I achieve these?
my select statement at the moment just returns all the rows that satisfy all the criteria.
so I loose some of the data which I must somehow get...