This SQL occur error?:

SELECT
COUNT(sub_select.*) as COUNT, sub_select.user_name,
sub_select.password
FROM
(
SELECT
user_name, password
FROM
USER sub_select
WHERE

user_name LIKE '%%'
AND password LIKE '%%'
AND name LIKE '%%'
AND surname LIKE '%%'
)


Content of my "USER" table:


user_name password name surname
_________ ______ __________ ________

g aa aa
h bb bb
i cc cc
j dd dd
k ee ee
l ff ff





Result of SQL must be :

COUNT user_name password
_____ ______ __________
6 g aa
6 h bb
6 i cc
6 j dd
6 k ee
6 l ff


==================

respect
esref atak