SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Require query

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2009
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Require query

    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

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,401
    Mentioned
    147 Post(s)
    Tagged
    4 Thread(s)
    What do you have so far? Post the query you managed to put together.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •