#1 Error Selecting on fields

[Nils van Velzen]

A problem occurs when a selection of observations is created based on data on a field that is both present in the time independent table "stations" as the time dependent table "data".

In the example we have observation locations X and Y in both tables. The returned SQL-error is

"SQL error: ambiguous column name Y"

for the (internally created query " select count(distinct stations.station_id) from stations inner join data on stations.station_id = data.station_id where ( Y >= 1 AND Y <= 31) AND (time BETWEEN 0.001000 AND 10.001000)"