Thread: Select query

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Posts
    6
    Rep Power
    0

    Post Select query


    i have two tables

    Table (a)
    id name
    1 aa
    2 bb
    3 cc
    4 dd


    Table (b)
    id name
    1 aa
    2 bb


    I need a output like this one
    Table(c)

    id name
    3 cc
    4 dd

    please help me!!!!!!!!!!!!!1
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,787
    Rep Power
    349
    Code:
    SELECT id,name
    FROM table_a
    MINUS
    SELECT id,name
    FROM table_b

IMN logo majestic logo threadwatch logo seochat tools logo