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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people