to save your query to SASUSER.PROFILE or another catalog of your choosing. Type IDWAGE in the Entry Name field. Type ID number and hourly wage in the description field. Select OK to save your query as ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...