Complex Outer Join Problem - all suggestiions appreciated

[Zoran Avtarovski]

I am using the following query and I'm not getting expected results:

SELECT *
FROM users as U, domain as D
LEFT OUTER JOIN
( user_hospitals as UH JOIN hospital as H on H.hospital_id = UH.hospital_id)
on U.user_id = UH.user_id
WHERE U.domain_id = D.domain_id

when the user_hospitals table is empty the query returns no data, but it should return everything in the users table and nulls for the other fields. That is how it works in SQL Server and SyBase.

If I change it to:
SELECT *
FROM users as U, domain as D
LEFT OUTER JOIN user_hospitals on U.user_id = UH.user_id
WHERE U.domain_id = D.domain_id

It works as expected. What am I missing. Does MySQL support this and if not what's the work around.

Zoran