On Tue, March 28, 2006 15:19, Philip M. McDonnell wrote: > That's exactly it. When there are no services/billing it shows > nothing because of this: > > WHERE c.account_number = '$account_number' AND removed <> 'y'"; > > Can't we remove the 'AND removed <> 'y'? What happens if we do? I > know it does show the client info then but will it show all cancelled > services too? > 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.
-- Regards, Doug ------------------------------------------------------- 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
