Originally Posted by AaronASterling

if they are all coming from a single table...call it testTable... then you would just say

Help with Code Tags

SQL Syntax (Toggle Plain Text)

SELECT location1, location2, location3 FROM testTable  WHERE ....

SELECT location1, location2, location3 FROM testTable WHERE ....

and then you can fill in whatever goes in the WHERE clause to get the result you want. In general you can list as many fields as you want plus other goodies in the select expression (the part where you tell it what you want) of a SELECT statement. They have to seperated by commas.