Finding NULL Values

I want to write a query to bring out any records in a table
where any of its fields contain a null value.
  I could do it in this way:
 
select
   *

from
   
customers
where
  name is
null
or
        role

 is null
or
        email
is null
u003c/p>
u003cp styleu003d"margin:0cm 0cm 0pt">u003cfont faceu003d"Times New Roman" sizeu003d"3">u003cfont coloru003d"#000000">However I want to perform a similar function for a
number of tables and the method above would mean more sql and maintenance.u003cspan>Â u003c/span>I was hoping there was a simple way to
do the same thingu003cspan> ie find any rows with a blank
fieldu003c/span>?u003cspan>u003cfont faceu003d"Arial" sizeu003d"2">Â u003c/font>u003c/span>u003c/font>u003c/font>u003c/p>u003c/span>u003c/font>u003c/div>
",0]
);
D(["ce"]);

//--> 
However I want to perform a similar function for a
number of tables and the method above would mean more sql and maintenance.
  I was hoping there was a simple way to
do the same thing
ie find any rows with a blank
field?