5. Complex queries

DEFINITION:

A complex query is a parameter query that searches using more than one parameter value i.e. on two or more criteria.

 

AND Query

It might be an AND query. The example below shows that the query is searching for event = birthday AND paid = yes

complex query

 

OR Query

It might be searching using two parameters for event = lunch OR event = birthday

complex query

 

NOT Query

The parameters might be looking for all events except for birthday.

complex query

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Complex Query