Hi Tore,
Thank you so much. You are correct, I had duplicate
records in the file. I haven't finish cleaning up the
table. Once I finish cleaning and run the query and
if I still duplicate, I will let you know.
Till then, thank you so much for the answer.
Unni
--- Tore Bostrup <[EMAIL PROTECTED]>
The only reason I could see for this would be if you have duplicates (across
date num1 num2 time) in both tables, or quadruplicates in one.
You join looks correct, so take a closer look at your data. Try running the
following queries:
SELECT A.date, num1, num2, A.time, Count(*)
FROM A
GROUP BY A
