Ayuda con SQL

[Teri]

Lo que parece que te falta es un WHERE

mysql> select username, signature from user left join
-> usertextfield on user.userid = usertextfield.userid WHERE signature <> ''
-> and signature IS NOT NULL limit 150,10;