i get data from two tables using inner join.
appId versionId
115 1
115 2
115 3
116 1
116 2
but i want to get data in below format
appId versionId
115 3
116 2
get highest version id records with appid
here appid and version id both are in different tables.
Regards
Nanda Kishore.CH