General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only