conditional view

i've this view:

CREATE OR REPLACE FORCE VIEW "ANM_FAMILIARE" ("ID_MAL", "MALATTIA", "ID_PAZ", "PARENTELA") AS
  SELECT id_mal, malattia, id_paz, parentela FROM anamnesi_ricovero NATURAL JOIN ricovero NATURAL JOIN malattie WHERE id_mal!=0 /

This works properly, except one case, when there is only one record and this record have id_mal==0, in this case ResultSet will be empty.

Can I modify this view, so when resultSet is empty will be used the same upon query without the WHERE clause.

Thank you all Received on Sun May 27 2007 - 13:49:41 CDT