Need help in query

[Anon]

i got a query like this:

UPDATE submissions
set sub_status = 'Normal'
where sub_id = (select submissions.sub_id
from submissions, assignments where submissions.assg_no = assignments.assg_no
and UNIX_TIMESTAMP(submissions.sub_datetime) <= UNIX_TIMESTAMP(assignments.soft_datetime));

i try to run this but the system always give me a syntax error.

is it an update query cannot have subquery? Or something wrong in my query?

please help

kelvin

[Anon]

if you are using mysql, then you cannot use sub-selects. You didn't mention which db you are using.

[Anon]

it's mysql ...
thanks a lot