[thelist] sql question

[Tab Alleman]

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;