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

SQL select statement From the shell type select * from us_states. You will see something like: select * from us_states; state_id | state_name | state_abbr | state_region ...

The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

SELECT statement. SQL Server 2000 introduces SQL collations, a large collection of named collation types that specify different combinations of character sets and sort orders.

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how.

Any query serves as a table to be queried by any other query, which is why queries may be nested almost infinitely within queries. Anyone who has seen a ten- or twenty-page SQL SELECT statement can ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.