[thelist] sql question

[Dallas Cahker]

Darn looks like I didnt send it to the list.  I appoligize thanks for
forwarding that to the list.

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;
>
> Here's my shot, without seeing your full table structure. If it works
> I can put it into inner join form for you.
>
> select O.orderid, subD.email, subD.dealerid
> from dealer_tm DT, order O, dealer subD
> where O.dealerid=subD.dealerid
>    and subD.dealerid=DT.subdealerid
>    and DT.dealerid='0325687A'
> order by subD.dealerid
>
> If that doesn't help, let us see your table structure (instead of
> describing it narratively) and we'll get you a solution.
>
> hth,
>
> --
> Matt Warden
> Miami University
> Oxford, OH, USA
> http://mattwarden.com
>
>
> This email proudly and graciously contributes to entropy.
> --
>
> * * 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 !
>