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

    Join Date
    Sep 2008
    Posts
    69
    Rep Power
    0

    Mysql query help


    I have two tables one is users and second is user_education.One users can have more than one education listing so i want to get the latest user education listing

    users
    ===============
    1-id
    2-email

    user_education
    ==============
    1-id
    2-user_id
    3-designation

    user id 1 has 4 enteries in user_education so i want to get the last record enter designation of the user
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,712
    Rep Power
    4288
    how do you know which one is the latest? you don't have a time stamp column!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo