[freeside-devel] mysql and complex queries

[Dave Burgess]

I've been playing around with the select, and I was wondering if this query
generates the right result dataset:

select * from cust_pkg
  left outer join part_pkg using (pkgpart)
    left outer join cust_main on (cust_main.custnum = cust_pkg.custnum)
      left outer join cust_svc on (cust_svc.pkgnum = cust_pkg.pkgnum)
        left outer join part_svc using (svcpart)
          left outer join svc_acct on (svc_acct.svcnum = cust_main.custnum)
            left outer join svc_domain on (svc_domain.svcnum =
svc_acct.domsvc)
              left outer join svc_forward using (svcnum)
                order by cust_main.custnum

ivan wrote:

> On Tue, Nov 20, 2001 at 12:29:50PM -0600, Dave Burgess wrote:
> > OK.
> >
> > I've been through the BNF for the SELECT statement in MySQL, and Version
> > 3 doesn't like this particular syntax at all.
>
> Do you mean to say it works in version 4?
>
> > - The parentheses might be a problem.  I wasn't able to use them for
> > grouping.
>
> Hmm, I thought I only used them where required by the JOIN syntax or for
> sub-queries.  Is MySQL missing support for subqueries?
>

[elided]