#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2016
    Location
    Lakewood, WA
    Posts
    218
    Rep Power
    17

    SQL: In this table but not that table


    The objective is to find Puid's that are in table a but not in table b.


    SELECT a.Puid FROM a LEFT OUTER JOIN b
    ON (a.Puid = b.Puid) WHERE b.Puid IS NULL


    Will this do it?
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,732
    Rep Power
    4288
    Originally Posted by Arty Zifferelli
    Will this do it?
    what happened when you tested it? ™
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo