> I'm not seeing any way around the sub-select. why would you want a way around it? that query looks okay to me what happened when you tested it? rudy http://r937.com/