Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>When run, an error comes up that says the order by statement is invalid. what is wrong?
>
>select data1.bundle+data2.bundles+data3.bundle+data4.bundles+data5.bundle+data6.bundle+data7.bundle+data8.bundle;
>as acBundle2;
>from data1, data2,data3,data4,data5,data6,data7,data8 ;
>where data1.grade + data1.siz + data1.length = data2.grade + data2.siz + data2.length;
>and data2.grade + data2.siz + data2.length = data3.grade + data3.siz + data3.length;
>and data3.grade + data3.siz + data4.length = data4.grade + data4.siz + data4.length;
>and data4.grade + data4.siz + data4.length = data5.grade + data5.siz + data5.length;
>and data5.grade + data5.siz + data5.length = data6.grade + data6.siz + data6.length;
>and data6.grade + data6.siz + data6.length = data7.grade + data7.siz + data7.length;
>and data7.grade + data7.siz + data7.length = data8.grade + data8.siz + data8.length;
>and data1.grade = gdValue and data1.siz = szValue and data1.length = 2 ;
>order by 2 ;
>into cursor myCursor
>
>
>Merry Christmas,
>JD
It might be my eyesight missing a comma, but dont you only end up with a single field (acBundle2) in myCursor, in which case you can only do order by 1
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement