Dear Sir/Madam, I am seeking help in SQL used in Sybase IQ Client. Please see attached spreadsheet. I work in the transportation industry working with commercial airline passenger's air fares. When data is requested by customers, I have to ensure that at least 3 airlines operate a certain route (i.e. New York JFK-London) prior to providing the data (security measure). My current query, as seen in "Query1" tab in the attached, is performing this correctly. This query is run route by route. I am trying to find a way to run it for all routes, with the taking into account the 3-airline rule. I am not having much luck so I turn to the EE's for input. Please advise with any questions. Thank you. James.