Problem with subquery

[Emilio Fuoco]

Hi !!

I use MySql 4.0.20a-nt

This is SQL query that creates problems:

SELECT x
FROM t
WHERE y = "4" AND z = "048" AND c = (

SELECT MAX(c)
FROM t
WHERE y = "4" AND z = "048"

)

t definition is:
x varchar(19)
y varchar(100)
z varchar(100)
c int(11)

MySql says me that there's an error with SQL syntax.

What is the error ?

Help me, please.
Thanks,
Emilio.