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 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. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    can you please explain the data in date column in table a.

IMN logo majestic logo threadwatch logo seochat tools logo