How to subselect in where statement in SQL Server CE?

i have the following select statement to get the last login from the user table. this works very well under sqlite, now im portin开发者_StackOverflowg the database and have Compact Edition from Micros