> Perhaps break the SQL into two parts, query 1 retrieves > customer data, query 2, retrieves services, and the interface > combines as necessary. > Otherwise you could do it with a single scalar subquery but > then you run into problems with older versions of MySQL.
Doug, this sounds like a better idea. Why not break it out into a couple of queries? Phil ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
