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