[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