query in MySQL -> MSSQL

[adrian_quah]

Hey guys!

The followinf query works perfectly in MySQL, now that my app is ported to MSSQL, there's an error..Pls tell me how i can change it 🙂 Thanks.

SELECT users_login.Login FROM users_login left outer join users_access_rights on users_login.Login = users_access_rights.Login where users_access_rights.Login is null ORDER BY users_login.Login

[adrian_quah]

Thanks...got it right already...was another query giving out the error.