I try the UNION clause and I get an error:
"SELECT's are not union compatible"


>I think you need the UNION clause:
>
>
>SELECT * FROM CUSTOMER ;
> WHERE MAXORDAMT > 50000 UNION ;
> (SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA')
>
>
>HTH!
>Mark
>
>>These two lines run fine if I run one after the other.
>>
>>SELECT * FROM V1 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