#750 INNER JOIN with execution time > 130 seconds

[Anonymous]

I have a MS SQL query which uses ONE "inner join" to combine 2 tables. Which works perfect. When i extent this by another "inner join" the time for execution changes from about 0.14 seconds to more then 130 seconds. I checked this query (copy paste) to another sql application and there the query is executed in less then a second on the same database, same table, same data.

Seems that the second INNER JOIN will slow something down.

[Nobody/Anonymous]

Screenshot of the behaviour.

[Nobody/Anonymous]

I forgot to write the version i use.

I use "SQuirreL SQL Client Snapshot-20090314_1612"