2 Replies Latest reply on Feb 20, 2011 10:56 AM by . Danihp

    Best way to 'join'  a date field from 2 tables.

    . Danihp

      Hi everybody,

       

      I'm looking the best way to 'join'  a date field from 2 tables.

       

      Tables are:

      comarques( Comarca (PK), latitude, longitude, ...)

      pluviometria( Comarca( FK to comarques), date, litres)

      Maximes( Comarca(FK to comarques), date, TempMax).

       

      -- Just to understand tables --------

      comarques = little regions.

      pluviometria = rainfall

      Maximes = temperature

      -------------------------------------------------

       

      the goal is to put together sum(liters) and avg(max temp) for the same month.