help: Sub or Nested Query into 1 Query

Hi,

I am having difficulty in figureing out how to create ONE query from nested querries. Is there one query that is equivaliant to Query #3?


Here is the 3 querries i used

QUERY x1

SELECT a.Col1 , a.Col2, a.Col3, Count(a.Col) AS CountA
FROM a
GROUP BY a.Col1, a.Col2, a.Col3
ORDER BY a.Col1;



QUERY x2:
SELECT a.Col1 , Count(a.Col) AS CountB
FROM a
GROUP BY a.Col1
ORDER BY a.Col1;


QUERY #3:

SELECT x1.Col1, x1.Col2, x1.Col3, x1.CountX, x2.CountB
FROM x1 INNER JOIN x2 ON x1.col1 = x2.col1
WHERE (CountA<>CountB)


Thanks!

there are actually several ways to do is

the easiest is just a straightforward substitution of X1 and X2 into X3 --

Hi,

Thanks for the quick response.

I was trying to substitute but forgot to use the AS;

from (...) AS x1


Marty