Thank you so much sir - fixed the problem!

Well - based on the results you want - it doesn't look like you need table 2 at all.

Something like this would get you the results you need...

select t1.sampleid,t1.classid,t2.resultid,t2.testid

from samples...

Yes it was.

Thanks for the responses guys - both worked well! You guys rock!

Sweet query - works great! Thanks!