Re: Complex Outer Join Problem - all suggestiions appreciated

[Zoran Avtarovski]

Thanks Jay,

I tried it and it didn't work, but I was able get the following to work:

SELECT *
FROM users as U
INNER JOIN domain as D
ON U.domain_id = D.domain_id
LEFT JOIN (user_hospitals as UH INNER JOIN hospital as H
on H.hospital_id = UH.hospital_id)
on U.user_id = UH.user_id;


The SQL Reference book I have uses the non-Ansi method I guess. Time for a better SQL reference. I'd love some recommendations on good SQL books, if you or anybody else has had positive experiences with any.

Zoran



Edited 1 time(s). Last edit at 03/06/2006 12:03AM by Zoran Avtarovski.