SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot txt3rob's Avatar
    Join Date
    Jul 2013
    Location
    Liverpool UK
    Posts
    199
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query to show all but not set ones

    can any one help i need to do a query for our user database

    I have two colums.

    One is Department
    One is Realname

    What i would like to do is to list all users apart from those who's department = no longer employed

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    So, select all rows from the table where the department is not 'no longer employed'
    I'm sure it won't be too hard to translate that in SQL. Give it a try, and if you can't get it to work, post your query here.


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
  •