Linq ve lambda Join/Where Örnek sql , select t.name,c.name from table t join chair c on c.id=t.id where t.color!=’Black’;