Hello Steve,

I am not sure exactly what you mean by "instances", however, when i was installing SQL Server on my computer, i did choose a Default Instance, from what i...

Thanks for the quick reply!

I realized however, that I made a mistake in the modification.

I am NOT using percentages, but rather 3 predetermined codes (100 for approved, 50 for pending,...

Thank you so much, I am not the Vince Caputo you know, I've never been to Omaha, don't know why anyone would want to go there, LOL!!!!!

But thanks again for...

I tried both LEFT OUTER JOIN and FULL JOIN, but it still yields no results.

Maybe i should include more info about the 2 tables.

TA (Teacher'sAssistants) Table

loginid classnumer...

Thank you rchagoor!

Don't know why I didn't think of that.

Regards,

Vinni