Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

Ok I want to run a SQL query while using the event procedure VB in MS Access.What I'm doing is trying to select a room of a building.So the form goes : Building (and they pick say Smith Hall) then ...

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

A basic SQL SELECT query has two main clauses: SELECT, which tells the server which columns you want to return, and FROM, which tells the server from which tables you want to retrieve data.

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