Hi,
Abovesnippet need to pass query in where clause instead of static values
TestEntities test = new TestEntities();
var result = from res in test.Customers
where new[] { how to pass linq query here to get ids from other table you pass static 1,2 i want to pass query here }.Contains(res.CustomerId)
select res;