note
Cine
I would suggest that you do it via two sql's
<code>
SELECT * FROM table a,table b WHERE a.id = b.id AND a.id IS NOT NULL AND a.id != '';
and
SELECT * FROM table a,table b WHERE a.first_name = b.first_name AND a.last_name = b.last_name
AND (a.id IS NULL or a.id = '') AND (b.id IS NULL or b.id = '');
</code>
<!-- <br><br><strong>Update:</strong><br><br> -->
<br><br><small>
<font color="green">T</font>
<font color="red">I</font>
<font color="blue">M</font>
<font color="white">T</font>
<font color="cyan">O</font>
<font color="black">W</font>
<font color="magenta">T</font>
<font color="red">D</font>
<font color="green">I</font></small>
187248
187248