Can't convert query to subquery

I have three tables: 
FCT: FDATE, X, Y , VALUE
BOS: DATE, STATION, VALUE
GRID_POINT: X,Y, STATION
I 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.STATION
but I was not able to convert it to a subquery. Can you help me with that?

    Requires Free Membership to View

    Login

A simple join of the three tables will give you the results you want, and I doubt that using subqueries would be any faster. Is there a particular reason why you want to use that approach?

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top