SQL JOIN Problem

[hirnstroem]

..es ist noch zu früh..

SQL-Code:

SELECT *
FROM [User] 
RIGHT JOIN [Key] 
ON Key.KeyID = User.KeyID
WHERE
(Number LIKE :Number
AND
Locked LIKE :Locked)
OR
(Username LIKE :Username
AND
Forename LIKE :Forename 
AND 
Surname LIKE :Surname)
ORDER BY Number;