Here are the statements:

CREATE TABLE SDT_LOG ( FILE_NAME VARCHAR2(50),

FILE_DESC ...

When I looked at the B Table, the information was exactly the same. I was getting something like this (shortened of course):

File_name Downloaded_ID Act_Code...

Yes, that makes sense. That tells me why the "Distinct" does not work in this case.

I would need to show all activities for every file and not just the...

Thanks for responding!

Yes, you are correct. If "Cindy" had only downloaded the file and that was all that was recorded for that file then one row would be retrieved and...

Thank you so much! I had to find out what Oracle liked because it did not like the function "Left" so I had to use this:

UPDATE TABLE ...

Ok, I see the reasoning now.

Jack and Matt..........thanks so much for your help!!!!!

You've saved the last 3 hairs I have left on my head from all of this!

LOL!!

Thanks! It's working!!

Being a newbie, I have to ask this dumb question........why do I need the Group By in order to just select the maximum dates from...

Thanks Matt, I'm still having problems. I leave work at 5:00, so I just got in this morning and started "playing" with this code again. I've tried a...

Thanks for responding!

I tried that too by just taking that part out and putting in string value

T1.File_Desc = 'LEVY'

Ok, it officially hates me!! LOL!!

I'm still getting the same error.

Thanks Jack, I'm still getting the same message.

Thanks for responding!

Well, I guess there could be a chance that the time would be different, but I took off the "seconds" so it would only be the hour and...

Thanks for responding Jack!

I get a "missing keyword" error.