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

    Join Date
    Oct 2011
    Posts
    1
    Rep Power
    0

    Join using first match


    Hi Friends,
    Please help Me with this requirement as I am new to sql..

    I need to join 2 tables based on first match.. I cldnot use distinct on the result, as distinct work with entire row..
    I cant use group by as well, since for group by hv to select all the columns which we need to display

    Thanks in advance.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    58
    Rep Power
    5
    ...
    where rownum = 1;

IMN logo majestic logo threadwatch logo seochat tools logo