> > > I'm quite sure it does not matter if I write
> > > t_person.dperson_id = d_person.dperson_id AND
> > > or
> > > d_person.dperson_id = t_person.dperson_id AND
> > > but please tell me if it does... :o)
> >
> > Logically there is no difference, however prevailing wisdom suggests
> > th
* DL Neil
> > I'm quite sure it does not matter if I write
> > t_person.dperson_id = d_person.dperson_id AND
> > or
> > d_person.dperson_id = t_person.dperson_id AND
> > but please tell me if it does... :o)
>
> Logically there is no difference, however prevailing wisdom suggests
> that you
Hi Roger,
> consider this select statement as an example:
>
> SELECT d_person.dispname, d_title.title
> FROM d_person, d_title, s_first, s_last, t_person, l_first, l_last
> WHERE
> t_person.dperson_id = d_person.dperson_id AND
> t_person.dtitle_id = d_title.dtitle_id AND
> l_first
