Thanks David.  That worked!  I didn't realize they weren't getting reset.  Or actually, I thought when nothing was found they would be set to null at that time (inside the...

Hi Marc,

Inside my "while" loop I have an "if/else" conditional.  The insert is in the else branch.  Inside that while loop I first select from the table to determine if...

Is there any way to get around this?

Thanks for the reply Phil.

It seems that if I do a left join with any one of the tables, I get back the expected number of rows for that particular...

my joining issues continue, but now with a different problem.

I have 4 tables, 1 table is kind of the central table and the other 3 are foreign key related details...

thanks a lot scott.  the method1 approach as written originally was returning 4760 rows and the method2 approach was returning 300 (more of what I was expecting).  I added another...

thank you.  that did the trick.  I love it when the solutions turn out to be fairly straight forward.

Thanks, this definitely gets me going in the right direction.  I have been playing with this statement trying to modify it more specifically to what I need which will be...