Home | Overview | Browser | Access | Login | Cookbook

Introduction to SQL

Simple queries are made up of 3 basic commands: select, from and where.

select - list the parameters you wish to extract (separated by commas) e.g. select ra,dec,kMag

from - list the table names you need to access e.g. from vhsSource

where - provide any constraints e.g. where kMagErr < 0.05

to give the full query

select ra,dec,kmag
from vhsSource
where kMagErr < 0.05

An introductory SQL tutorial can be found here.