Subqueries Using Nested SELECT Statements

The BASIS ODBC Driver 2.0 is capable of using nested SELECT statements for subqueries, for example:

SELECT prod_cat FROM item WHERE prod_cat IN
 (SELECT prod_cat FROM category WHERE rec_date > '1998-0101')



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.