5. Working with QBF Operations : QBF Retrieve Operation : Search Qualifications : Complex Queries
 
Share this page                  
Complex Queries
The following figure is an example of a complex query that utilizes comparison operators, logical operators, and wild card characters. The query searches for information from a JoinDef consisting of the Staff table and the Tasks table. Specifically, it searches for records of employees whose names begin with the letter B, whose hourly rate is less than $50, and who have either worked in the Design phase or have worked more than 25 hours in the Implement phase.
QBF interprets the search conditions on this form as follows:
Display the data if name = B* and hourly rate <50 and
(task = Design or (task = Implement and hours >25))