Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Could you be so kind and type the code for me?
I have tried several things and I still can't get it right.
Thank you again
>>These two lines run fine if I run one after the other.
>>
>>SELECT * FROM CUSTOMER WHERE MAXORDAMT > 50000
>>
>>SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA'
>>
>>
>>
>>If I try to nest them, they don't run, what am I doing wrong?
>>SELECT * FROM CUSTOMER ;
>> WHERE MAXORDAMT > 50000 AND ;
>> (SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA')
>>
>>
>>Thank you in advance
>
>Your subquery syntax is incorrect. First of all, after the AND in your where clause, and before the subquery, you need V1.< field > [NOT] IN. Secondly, your subquery should only return one column, the Customer field which matches the field in V1.
>
>HTH,
>Rich.
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