Read this SQL tutorial to learn when to use SELECT ... SELECT, JOIN, UNION and subqueries. SEE: Take advantage of these quick SQL lessions with this certification bundle from TechRepublic Academy ...

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 ...