-------------- SELECT * from cs1 -------------- id timestamp_ numeric_val 1 2018-01-09 21:59:02 11.11 -------------- SELECT * from cs2 -------------- id timestamp_ numeric_val 1 2018-01-09 21:59:02 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) -------------- id timestamp_ numeric_val numeric_val 1 2018-01-09 21:59:02 11.11 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) WHERE cs1.numeric_val <=> cs2.numeric_val -------------- -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) WHERE NOT (cs1.numeric_val = cs2.numeric_val) -------------- id timestamp_ numeric_val numeric_val 1 2018-01-09 21:59:02 11.11 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) WHERE NOT (cs1.numeric_val <=> cs2.numeric_val) -------------- id timestamp_ numeric_val numeric_val 1 2018-01-09 21:59:02 11.11 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) WHERE cs1.id <=> cs2.id -------------- id timestamp_ numeric_val numeric_val 1 2018-01-09 21:59:02 11.11 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id,timestamp_) WHERE NOT (cs1.id <=> cs2.id) -------------- -------------- SELECT * FROM cs1 JOIN cs2 USING(id) WHERE cs1.id <=> cs2.id -------------- id timestamp_ numeric_val timestamp_ numeric_val 1 2018-01-09 21:59:02 11.11 2018-01-09 21:59:02 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(id) WHERE NOT (cs1.id <=> cs2.id) -------------- -------------- SELECT * FROM cs1 JOIN cs2 USING(timestamp_) WHERE cs1.id <=> cs2.id -------------- timestamp_ id numeric_val id numeric_val 2018-01-09 21:59:02 1 11.11 1 22.22 -------------- SELECT * FROM cs1 JOIN cs2 USING(timestamp_) WHERE NOT (cs1.id <=> cs2.id) --------------