>Thanks a lot. Sergey.
>
>I replaced
>

ON m.f_year + m.type_code + m.sal_no = d.f_year + d.type_code + d.sal_no

>with
>

ON m.f_year = d.f_year AND m.type_code = d.type_code AND m.sal_no = d.sal_no

>It changed everything. I got 6200 in just matter of seconds.
>
>1. What's the difference between them?

I explained it in my prevous message.

> If the first 1 is not correct then why SQL accepts it?

It's valid expression but it's used incorrectly by you

>2. I am overusing LEFT OUTER JOINs what's the alternet?

Only use them when you have to

>3. Everytime i format the query and save it in View Desigener and reopen It looses my format.

I do not use View Desigener or Query Designer for that reason.

>
>
>
>>It seems that you're overusing LEFT OUTER JOINs. Do you really need all of them to be such?
>>All JOIN expressions are incorrect. SQL Server does not have compound indexes so they cannot be optimized. The join should be on each column separately
>>

>>INNER JOIN dbo.sal_dtl AS d
>> 	ON m.f_year + m.type_code + m.sal_no = d.f_year + d.type_code + d.sal_no
>>
>>-- should be
>>
>>INNER JOIN dbo.sal_dtl AS d
>> 	ON m.f_year = d.f_year AND m.type_code = d.type_code AND m.sal_no = d.sal_no
>>
>>-- and so on
>>

>>
>>I also would recommend to reformat the query for readability.
>>