;
> SELECT A.date, num1, num2, A.time, Count(*)
> FROM A
> GROUP BY A.date, num1, num2, A.time
> HAVING Count(*) > 1
>
> SELECT B.date, num1, num2, B.time, Count(*)
> FROM B
> GROUP BY B.date, num1, num2, B.time
> HAVING Count(*) > 1
>
>
> HTH,
>
All,
I have two tables like the following
table A
date num1 num2 time
table B
date num1 num2 time
When I run a query like the following
select * from A as a inner join B as b
on a.num1 = b.num1 and a.date=b.date and a.num2=b.num2
and a.time=b.time
I am getting the results repeated 4 times, co