>I was able to get it to work using derived tables.. they seem kind of like a cursor in VFP.
Congratulations :o))) Can you show me how?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.