|
|
|
|
|
The selection criteria in a single SELECT statement are treated in a logical OR fashion. Thus if more then one select condition is specified in one SELECT statement any record meeting any one of the conditions will be included. If a record meets both the include and the exclude condition the record is excluded. Multiple SELECT statements are treated in a logical AND fashion. Thus if a record is selected by one statement and not by another SELECT statement the record is rejected.