vsa logo
VSA will soon move to
vsa.roe.ac.uk

VSA Home
Start Here
Data Overview
Known Issues
the Surveys
Coverage Maps
Schema browser
Data access
Login
Archive Listing
GetImage
MultiGetImage
Region
Freeform SQL
CrossID
SQL Cookbook
Q&A
Glossary
Release History
Gallery
Publications
Monitor
Downtime
Links
vsa logo bottom
IFA     ROE
Home | Overview | Browser | Access | Login | Cookbook 
  VSA logo

Introduction to SQL

Queries are carried out on the VSA database using SQL (Structured Query Language).

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.



Home | Overview | Browser | Access | Login | Cookbook
Listing | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

vsa-support@roe.ac.uk
24/1/2014