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