ajoo Posted February 11, 2019 Share Posted February 11, 2019 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 ! Link to comment Share on other sites More sharing options...
ajoo Posted February 11, 2019 Author Share Posted February 11, 2019 OK, I got it. Thanks ! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.