convert a query into one using joins

[ajoo]

Hi !

I have a query

select @rownum:=@rownum+1 as row, tbl_country.Level, tbl_country.TimeOfLogin, register.email, tbl_country.SessionStatus 
FROM tbl_country, register,(SELECT @rownum:=0) r  
WHERE tbl_country.UserLogin = ? AND (tbl_country.UserLogin = register.Username) order by row desc limit 1;

that works great but I want to change this to use JOINS. Please can someone show me if and how that can be done.  I am not sure how and where to place

(SELECT @rownum:=0) r

in the query with joins.  I have tried but it fails each time.

Thanks all !

 

[ajoo]

OK, I got it. Thanks !