[thelist] SOLVED sql question
Dallas Cahker
christmasfruitcake at gmail.com
Tue Apr 11 15:57:48 CDT 2006
I think I got it.
SELECT
`dealer_tm`.`dealerid`,
`dealer_tm`.`subid`,
`dealer`.`dealerid`,
`dealer`.`name`,
`orders`.`orderid`,
`orders`.`dealerid`
FROM
`dealer_tm`
Inner Join `dealer` ON `dealer_tm`.`dealerid` = `dealer`.`dealerid`
Inner Join `order` ON `dealer`.`dealerid` = `order`.`dealerid`
WHERE
`dealer_tm`.`subid` = '0325687A'
ORDER BY
`dealer_tm`.`dealerid` ASC
On 4/11/06, Tab Alleman <talleman at lumpsum.com> wrote:
>
> Where did you get DT.tmid?
>
> Does this FROM structure shed any light?:
>
> FROM Dealer mgr
> LEFT OUTER JOIN Dealer_TM dtm ON mgr.dealerid=dtm.dealerid
> LEFT OUTER JOIN Dealer sub ON dtm.subid=sub.dealerid
> LEFT OUTER JOIN Order o ON sub.dealerid=o.dealerid
>
> HTH
>
> thelist-bounces at lists.evolt.org wrote:
> > No results.
> > +----------------+--------------+------+-----+---------+-------+
> >> Field | Type | Null | Key | Default | Extra |
> > +----------------+--------------+------+-----+---------+-------+
> >> dealerid | int(11) | NO | PRI | 0 | |
> >> email | varchar(70) | NO | | | |
> >> password | varchar(32) | NO | | | |
> >> name | varchar(150) | YES | | NULL | |
> >> company | varchar(150) | YES | | NULL | |
> > +----------------+--------------+------+-----+---------+-------+
> >
> > +----------+---------+------+-----+---------+-------+
> >> Field | Type | Null | Key | Default | Extra |
> > +----------+---------+------+-----+---------+-------+
> >> dealerid | int(11) | NO | PRI | 0 | |
> >> subid | int(11) | NO | MUL | 0 | |
> > +----------+---------+------+-----+---------+-------+
> >
> > +-----------------+-------------+------+-----+---------+-------+
> >> Field | Type | Null | Key | Default | Extra |
> > +-----------------+-------------+------+-----+---------+-------+
> >> orderid | int(11) | NO | PRI | 0 | |
> >> dealerid | int(11) | YES | | NULL | |
> >> billingid | int(11) | YES | | NULL | |
> >> shippingid | int(11) | YES | | NULL | |
> > +-----------------+-------------+------+-----+---------+-------+
> >
> > On 4/11/06, Matt Warden <mwarden at gmail.com> wrote:
> >> On 4/11/06, Dallas Cahker <christmasfruitcake at gmail.com> wrote:
> >>> SELECT O.orderid, D.email, D.dealerid, DT.dealerid AS dealeridDT,
> >>> DT.tmid FROM dealer_tm DT INNER JOIN dealer D
> >>> ON D.dealerid = DT.dealerid
> >>> INNER JOIN order O
> >>> ON D.dealerid = O.dealerid
> >>> WHERE DT.dealerid = '0325687A'
> >>> ORDER BY D.dealerid;
>
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list