Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Because the SQL procedure is based on the Structured Query Language, it works somewhat differently than some SAS procedures. For example, the SQL procedure executes without a RUN statement when a ...

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

See SQL Procedure's Interaction with SAS/ACCESS Software for detailed information. Note: It is recommended that you use the new SAS/ACCESS LIBNAME statement to access your DBMS data more directly and ...