On Thu, 2009-02-12 at 14:21 -0800, Adrian Klaver wrote:
> On Thursday 12 February 2009 11:37:37 am Paolo Saudin wrote:
>
>
> SELECT fulldate,sensor
> FROM (SELECT fulldate,sensor,count(sensor)
> FROM (SELECT 1 AS station, fulldate, meanvalue AS sensor FROM table1
> UNION
> SELECT 2, fulldate, meanvalue FROM table2 ORDER BY
> fulldate,sensor) AS x
> GROUP BY fulldate,sensor) AS y
> WHERE y.count>1;
>
>
> and got-
>
> fulldate | sensor
> ---------------------+--------
> 2009-01-01 00:00:00 | 12.3
> 2009-01-01 02:00:00 | 82.1
> 2009-01-01 03:00:00 | 79.8
> 2009-01-01 04:00:00 | 77.2
You might want to do a UNION with all your tables to add a field to
identify the table, and use min() and max() to show the offending
tables.
