For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...

correlated subqueries can sometimes be slow to run. However, they significantly extend the range of queries that can be expressed as a single SQL query and are well worth mastering. Let us refer to ...

The only book to go beyond introductory coverage of Object-Role-Modeling and provide all the in-depth instruction you need to transform knowledge from domain experts into a sound database design.