List:General Discussion« Previous MessageNext Message »
From:David T-G Date:August 9 2003 4:12am
Subject:arbitrary ordering
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, all --

I have a few tables something like

  create table SURVEY
    ( SID int primary key not null auto_increment,
      SNAME varchar(20),
      QUESTION_ORDER varchar(20) ) ;
  create table SURVEY_QUESTION
    ( QID int primary key not null auto_increment,
      QBODY varchar(255),
      OPTION_ORDER varchar(20) ) ;
  create table SURVEY_OPTION
    ( OID int primary key not null auto_increment,
      OBODY varchar(255) ) ;

and in the QUESTION_ORDER field I store a list of numbers "12 13 21 14"
while in OPTION_ORDER it might be "432 435 435 550" or such.  I want to
do a select on all three (double left join, if I am starting to grasp
this stuff :-) ordered first by the QID as shown in QUESTION_ORDER and
then by the OID as shown in OPTION_ORDER.

Is there a way to tell my join-and-select statement the sort order based
on the contents of another field (but not simply sorting on that field)?


TIA & HAND

:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE/NHTHGb7uCXufRwARAtPvAKDql3YjpBwwEpS5trzncnOzeTjXUACfZo93
Kep54aY/EeVXaCXXlItbKl0=
=qi7g
-----END PGP SIGNATURE-----
Thread
arbitrary orderingDavid T-G9 Aug
  • Re: arbitrary orderingAndy Jackman10 Aug
    • Re: arbitrary orderingDavid T-G10 Aug
  • Re: arbitrary orderingAndy Jackman10 Aug
    • Re: arbitrary orderingDavid T-G11 Aug