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

    Join Date
    May 2011
    Posts
    6
    Rep Power
    0

    Select query from two tables


    I have two tables a and b
    column names are id and date.
    Data type of date in a and b are different

    table (a)

    date id
    10-DEC-01 2:08:39 PM 1
    10-DEC-01 2:08:39 PM 2
    10-JAN-02 10:10:22 PM 3
    10-JAN-02 10:10:22 PM 4
    10-JAN-02 10:10:22 PM 5


    table (b)
    date id
    10-DEC-01 1
    10-DEC-01 2



    I need table b like this one
    table (b)


    date id
    10-DEC-01 1
    10-DEC-01 2
    10-JAN-02 3
    10-JAN-02 4
    10-JAN-02 5


    please help me!!!!
  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
    Originally Posted by jaseervp
    Data type of date in a and b are different
    And what are the data types of those columns?

IMN logo majestic logo threadwatch logo seochat tools logo