-----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) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- 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----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]