FCT: FDATE, X, Y , VALUE BOS: DATE, STATION, VALUE GRID_POINT: X,Y, STATIONI want to extract FDATE, OBS.STATION, FCT.VALUE and OBS.VALUE. I was able to do that with this query.
SELECT OBS.STATION,FDATE,FCT.VALUE ,OBS.VALUE FROM FCT,OBS,GRIDSELECT OBS.STATION,FDATE,FCT.VALUE,OBS.VALUE FROM FCT,OBS,GRID WHRE FDATE=DATE AND FCT.X=GRID_POINT.X AND FCT.Y=GRID_POINT.Y AND OBS.STATION=GRID_POINT.STATIONbut I was not able to convert it to a subquery. Can you help me with that?
This was first published in July 2006