thks kenneth..for clarification..thats great!!..i had no idea of virtual tables..any link on net where i can find more info?

thks

thks kenneth..could yu explain this a bit...is this a subquery? what is x at the end of query after )? Basically,i am just clueless..

regards

tal