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?
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.