-- this is optimized also

select so.* from SalesOrderdetail as so

where so.CustomerID IN (select s.CustomerID from sales as s)

-- SQL TEAM forgets to optimize this

select so.* from SalesOrderdetail as so

JOIN sales as s ON so.CustomerID =s.CustomerID