Hmmm, I get "Clustered Index Scan" as both PhysicalOp and LogicalOp in

SQL 2008 with Auto Statistics "false".

With Auto Statistics "true" I get one inner join.

I have to check why Auto Statistics was "false" on that test database...