Table locks(myql 4.1)

[mikerh9]

I used mysql-3.23. I run "large" large query and they don't crashed. When I run the same query on myql 4.1 some tables are locked.

What can cause it?

[mikerh9]

This query I was talking about.

SELECT actor.first_name, actor.last_name,
A.dba, A.source, A.processor, A.partner, A.date_send, A.a_status, A.date_received A.notes,C.request, C.request2, C.request, C.month, C.submitted,
D.status, D.processor, D.approve, D.month, D.contract,
B.b, B.switch, B.var, B.download, B.follow_up

FROM actor, A, C, D, B
where actor.id = A.actor_id and C.a_id = A.id and
D.a_id = A.id and B.a_id = A.id;