HI

I want to run a SELECT Statement from 2 tables like this:

SELECT *;
FROM Table1 ;
LEFT OUTER JOIN Table2;
ON Table1.Key = Table2.Key;
WHERE Table1.Field = cValue;
AND Table2.Field = cValue2

The only problem, is that this isn't optimised if I only populate cValue2.

Any ideas on how I can speed this up?

Thanks
Kev