Michael Vilhelmsen wrote:

>
> An SQL statement like the below, will it make 4 sub selects for each
> record in table VD ?

Yes.

>
> If Yes - Can it be modified to only make one select for each record ?

No, but don't worry. Since the conditions are identical, after the
first subselect, all pages (index, pointer, & data) will be in cache and
the performance will be excellent, despite the ugliness of the code.


Regards,


Ann