Vlad

If you tried:

SELECT * ;
FROM T1 ;
LEFT OUTER JOIN T2 ;
ON T1.Key = T2.Key ;
WHERE T1.a = '' ;
AND T2.bb = 'qwwe'

And Table 1 had 37000 records, and table 2 had 20000. It would be very slow.

Can you seem my point, because the Select will be running from Variables, these variables can sometimes be blank, depending on the criteria.

Sorry, I know I should have mentioned that earlier.

Thanks
Kev