Select data

select O3.FECHA AS FECHA, NOx.HORA AS HORA,O3.PED AS O3N,NOx.PED AS NOx,NO2.PED AS NO2,RH.PED AS RH, TMP.PED AS TMP, WSP.PED AS WSP,WDR.PED AS WDR,SO2.PED AS SO2,CO.PED AS CO FROM O3,NOx,NO2,RH,TMP,WDR,WSP,SO2,CO WHERE NOx.FECHA=NO2.FECHA AND NOx.FECHA=O3.FECHA AND NOx.FECHA=RH.FECHA AND NOx.FECHA=TMP.FECHA AND NOx.FECHA=WDR.FECHA AND NOx.FECHA=WSP.FECHA AND NOx.FECHA=SO2.FECHA AND NOx.FECHA=CO.FECHA AND NOx.HORA=12 AND NO2.HORA=12 AND RH.HORA=12 AND TMP.HORA=12 AND WDR.HORA=12 AND WSP.HORA=12 AND SO2.HORA=12 AND CO.HORA=12 AND O3.HORA=12 AND NOx.PED >0 AND NO2.PED>0 AND RH.PED>0 AND TMP.PED>0 AND WSP.PED>0 AND WDR.PED >0 AND SO2.PED>0 AND CO.PED>0 AND O3.PED>0