hi! i tried this before, but ist doesn't work. i have to order by name first:
.... ORDER BY person.name, peron.phone.priority ...
cu
markus
On Wed, Nov 21, 2001 at 09:19:13AM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> <query> ORDER BY priority
>
> should do it..
>
> Grtz,
> Michel
>
> On Wed, 21 Nov 2001, Markus Garscha wrote:
>
> > hi!
> >
> > i have a 1:n relation, a "person" who has multiple "phone"-numbers. each
> > phonenumber as a field "priority" of type integer which is used for sorting
> > the phonenumbers.
> >
> > the problem: when i query a person (with all its numbers), the numbers are
> > random.
> >
> > how to order the phonenumbers per person by priority?
> >
> >
> > cu
> > markus
> >
> > --
> > -------------------------------------------------------------------------------
> > Markus Garscha email: [EMAIL PROTECTED]
> > Hartmannstr. 129 fon: 09131/626715
> > 91058 Erlangen fax: +49 89 244356966
> > pgp-keyid: 0xEE18AF3B
> > -------------------------------------------------------------------------------
> >
> >
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
--
-------------------------------------------------------------------------------
Markus Garscha email: [EMAIL PROTECTED]
Hartmannstr. 129 fon: 09131/626715
91058 Erlangen fax: +49 89 244356966
pgp-keyid: 0xEE18AF3B
-------------------------------------------------------------------------------
msg02514/pgp00000.pgp
Description: PGP signature
