Get Data using Joins in sqlserver

Question

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