SELECT users_login.u_id AS u_id, users_login.u_account AS u_account, users_login.u_login AS u_login, users_details.u_first_name AS first_name, users_details.u_last_name AS last_name FROM users_login FULL JOIN users_details ON (users_login.u_id=users_details.u_id) WHERE users_login.u_account='smod' OR users_login.u_account='nmod';
Pomoże ktoś? Bo pomysły mi się pokończyły...
Edit - znalazłem

