> MYSQL VERSION > FROM (fscd_county x JOIN fscd_client c ON (x.countyid = > c.countyid) > JOIN fscd_state s on (s.stateid = x.stateid)) > LEFT OUTER JOIN fscd_survey u ON c.clientid = > u.clientid > LEFT OUTER JOIN fscd_post p ON c.clientid = > p.clientid > WHERE x.active = 1 > AND c.active = 1 > AND (p.active = 1 OR p.active is null) > AND (u.active = 1 OR u.active is null) <!--- Is this > the preferred method > in Mysql? --->
Hi Deanna, I just realized this message didn't seem to reach the list earlier. Have you tried this? FROM fscd_county x JOIN fscd_client c ON (x.countyid = c.countyid) JOIN fscd_state s on (s.stateid = x.stateid) LEFT JOIN fscd_survey u ON (c.clientid = u.clientid and p.active = 1) LEFT JOIN fscd_post p ON (c.clientid = p.clientid and u.active = 1) WHERE x.active = 1 AND c.active = 1 The extra set of parenthesis around the inner join statements would make me a little leery. Oracle 9i also added support for the standard outer join syntax shown here. Personally I also prefer to always include the parenthesis around the conditions of a join statement for clarity if nothing else. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237856 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
