Thank You !!! Apparently its time to update myself.

Thanks, I'll keep your suggestion in mind next time...

No, not homework... I'm new to SQL.

Very helpful, thank you.

I constructed what I needed with your guidance.

Have you tried going to Scheduled Tasks , Properties of this task, and setting / changing the <RunAs> credentials?

Thank You....

These are all great responses. However, they seem not to fit my needs.

The reason I'm looking for a way to do this is to give me a linear result,

a...

I'm kind of trial and error guy. I haven't tried anything.

I just made the observation in my data, that I am going

to need to do this. ...

Thanks ALL, LEFT OUTER JOIN is working.

Tom