Ok, here's a follow on question.

This SQL does not have a WHERE clause. The clause will be built dynamically
based on user pref's.

Since the station is in a separate table, it seems like I'll have to
query the station table for the Id:

SELECT Id
 FROM Station;
 WHERE Station_Name = PADR(ThisForm.txtStation.Value, 20, " ")

Then use the Id returned in my other query as part of the WHERE clause:

 cWhere  = cWhere  + " and st.Id = '" + TRANSFORM(nStationId) + "'"

I'm not entirely sure of the right way to do this in SQL. Does not sound ok?

Thanks