>Can someone help me about SELECT-SQL command.
>
>I need an explanation of clauses EXISTS, SOME and ANY.
Found this in the Help File....maybe it helps describe for you.
When the filter condition includes ANY or SOME, the field must meet the comparison condition for at least one of the values generated by the subquery.
company < ANY ;
(SELECT company FROM customer WHERE country = "UK")
This example checks to see whether at least one row meets the criterion in the subquery. When the filter condition includes EXISTS, the filter condition evaluates to true (.T.) unless the subquery evaluates to the empty set.
EXISTS ;
(SELECT * FROM orders WHERE customer.postalcode=orders.postalcode)
