[thelist] sql question

[Dallas Cahker]

This is my query its name is Oliver, beautiful isnt he?  Doesnt work and I
kinda had an idea it wouldnt.  :(

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;

What I am trying to do is get information from three tables (DEALER, ORDER,
DEALER_TM) what I am trying to get specifically is to get all the orders for
a certain dealer manager with them ordered by sub dealers.  The relationship
between dealer manager and sub dealer are in DEALER_TM table, Order
information is in ORDER and the dealerid points to the sub dealer, DEALER
table holds the information about the dealer, and dealer manager.

Any ideas?