Require query

[nagasunil]

Name payment_type payment_done
sunil cheque 0
mrudula transfer 0
shahid credit 0
keerthi credit 1


the above table have the records like that

i need out put as below

sunil
mrudula
keerthi

Requirement is when payment_type is credit & payment done is 0, then those records shoul blocked.

please send the query asap.

waiting for your reply

[guido2004]

What do you have so far? Post the query you managed to put together.