INNER JOIN problem

[Lokot, Tim]

Is there a limit to the number of inner join statements within an sql
statement.  I am using the following statement:
 
SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL

    FROM (suburb_def 
    INNER JOIN church_location ON suburb_def.ID = church_location.Suburb) 
    INNER JOIN (neighbour_def 
    INNER JOIN suburb_map ON neighbour_def.ID = suburb_map.Neighbour) ON
suburb_def.ID = suburb_map.Node 
    WHERE ((suburb_map.Node) = $suburb) 
    ORDER BY suburb_def.Suburb, church_location.Name;
 
This seems to return an invalid result set when called from a php script
 
Regards,
 
Tim Lokot
Software Engineer
 
S1 Corporation
Level 2, 14 Queens Road
Melbourne, VIC 3004 Australia
 
T: +61 3.9258.1139    F: +61 3.9804.5899