-----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-----
