Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...

A question asked about data contained in two or more tables in a relational database. The relational query must specify the tables required and what the condition is that links them; for example ...

When the query finishes, the connection to the DBMS is terminated and the libref is deassigned. The USING clause must be the last clause in the SELECT statement. Multiple LIBNAME statements can be ...