SELECT * FROM table_3
EXCEPT
SELECT * FROM table_4;

SELECT
	COALESCE(t3.col_1,t4.col_1) AS col_1,
	t3.MaxCol AS T3MaxCol,
	t4.MaxCol AS T4MaxCol
FROM
	table_3 t3
	FULL JOIN table_4 t4 ON
		t3.col_1 = t4_col1;

quote:

---

Originally posted by neosapien

Hi there

I have a table extracted using the following query:

select col_1, max(col_2) from table_1 where
col_3_val = 2 and
col_4_val > '2012-03-11 00:00:00.000' and col_1 in
(select col_1 from table_2 where
col_5_val in (1024, 1053) and
col_4_val > '2012-03-11 00:00:00.000')
group by col_1 order by 1

and another table using the same query but with one extra condition in the parent query. Both tables have exactly the same number(2) of columns and the field types(integer) are also the same. Lets say the output gives table_3 and table_4. I want to find out for each value in the second column table_3, the difference from the corresponding value in the second column of table_4.

Can someone help me please?

---

SELECT
FROM (first query) q1
INNER JOIN (second query) q2
ON q2.id = q1.id
WHERE (q2.maxcount - q1.maxcount ) >15