-- Stars with multiple measurements, version 2
-- Another way to do the above query, as suggested by JNH.  
-- This uses only the Star view wich contains summary information only.
-- The most recent detections will not be considered.
-- NOTE: This query does not return results at the moment becouse is using 
--		 dummy results
SELECT TOP 100
    objID, 
    n_g, gMax, gMin,
    n_r, rMax, rMin,
    n_i, iMax, iMin,
    n_z, zMax, zMin,
    n_y, yMax, yMin
FROM Star
WHERE
    (n_g > 1 AND gMax - gMin > 0.1) OR
    (n_r > 1 AND rMax - rMin > 0.1) OR
    (n_i > 1 AND iMax - iMin > 0.1) OR
    (n_z > 1 AND zMax - zMin > 0.1) OR
    (n_y > 1 AND yMax - yMin > 0.1)
