Cita: select firstname, EmailAddress from Contact_Manager2_Contacts
where EmailAddress IS Not NULL and firstName <> ''
Ups..tome una query que tenía por ahi.
.. pero en tu caso podría quedar como:
Cita: select username, signature from user left join usertextfield on user.userid = usertextfield.userid and signature <> '' and signature IS NOT NULL