sql - Update the table with one record returned by inner join clause -

i have 1 table called tplayergroup have columns as: groupid, playerid, createddtm etc.

i'm using query:

select top 1 * tplayergroup tpg tpg.playerid = 617734 order tpg.createddtm desc 

so above query 1 record. want inner join ttrip(tripid, groupid, playerid) table on playerid of both table, making sure while inner joining tplayergroup , ttrip should return 1 row(condition should latest createddtm of tplayergroup table) rather common data.

how accomplish it?

thanks in advance..

not sure trying update exactly, correct syntax is:

update t1 set t1.c2 = t2.c2 t1    inner join t2 on t2.c1 = t1.c1   inner join t3 on t3.c1 = t1.c1