mysql and complex queries

ivan ivan at 420.am
Mon Nov 19 23:59:45 PST 2001


can mysql handle this query?  if not, what would need to be changed?

SELECT * FROM cust_main left outer join (
  ( cust_pkg left outer join part_pkg using(pkgpart)
  ) left outer join (
    (
      (
        ( cust_svc left outer join part_svc using (svcpart)
        ) left outer join (
          svc_acct left outer join (
            select svcnum, domain, catchall from svc_domain
            ) as svc_acct_domsvc (
              svc_acct_svcnum, svc_acct_domain, svc_acct_catchall
          ) on svc_acct.domsvc = svc_acct_domsvc.svc_acct_svcnum
        ) using (svcnum)
      ) left outer join svc_domain using(svcnum)
    ) left outer join svc_forward using(svcnum)
  ) using (pkgnum)
) using (custnum)
 

(apologies if the SQL indentation is weird)

-- 
_ivan



More information about the freeside-devel mailing list