This example shows how to use keyword IN.  
  The query retrieves all data from table "Employee" concerning employees with names 'Roberto' or 'Roger'. 
 
select e1."*"
from "employee" e1
where (e1."FirstName" in ("Roberto", "Roger"))
order by e1."FirstName" asc
 
Download Absolute Database | Learn more |   
 
 |   
 | 
 
Current version: 7.97
    
     Released: May 27, 2025
    Price: $ 149
    
       
 |   
 |   
 
 
  
   
 
| 
 Thanks again for the superb tech support, I was worried I'd hit a brick wall this close to the finish line. Even working on the weekend... you guys rock!!!
 
 
  Bob Boyd        
 
 |   
 |   
 
 |