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

Reindexing tables is an important part of good database housekeeping, because it reorganizes the indexes and restores speedy access. Microsoft's SQL Server has a handy command that rebuilds all ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

If you use the SQL command line to mine the records in your tables, you’ll discover that a JOIN may be the best tool for finding the information you need. This week, I’ll explain the basic ...

In this tutorial, we will step through installing ... To cap it all off, we’ll execute a query against two related tables by using SQL join clauses. Along the way, I will suggest some GUI ...

Before I can explain JOIN clauses, you need to understand foreign keys and relations between tables. I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...