> Perhaps I'm not understanding correctly, but you can still use the while > loop if only a single row is returned, it'll just run the loop once. > > -Stut >
That's what I thought also and is how I had it setup at first! But for some strange reason it always returned 4 identical results instead of just one. I took the query and placed it in several SQL editors and all of them only gave me one result back so I decided to try a different approach.
