I have some List with values and i need to get record from sobject for each element from that list. So it looks like that. But its very close to limitations. Any ideas gow to do it? Its necessary to check every element from list so IN is not enough. I need to get one element from Object for each element from list, when IN gives me all elements.

for( String element: list) {
 Select id  from Object Where  field = (Select field2 from Object2 where id = element)
}

I have some List with values and i need to get record from sobject for each element from that list. So it looks like that. But its very close to limitations. Any ideas gow to do it? Its necessary to check every element from list so IN is not enough. I need to get one element from Object for each element from list, when IN gives me all elements. So if i need one record for each element in list i can select all and after it via adding to map and check if id already in map?

for( String element: list) {
 Select id  from Object Where  field = (Select field2 from Object2 where id = element)
}

I have some List with values and i need to get record from sobject for each element from that list. So it looks like that. But its very close to limitations. Any ideas gow to do it? Its necessary to check every element from list so IN is not enough.

for( String element: list) {
 Select id  from Object Where  field = (Select field2 from Object2 where id = element)
}

I have some List with values and i need to get record from sobject for each element from that list. So it looks like that. But its very close to limitations. Any ideas gow to do it? Its necessary to check every element from list so IN is not enough. I need to get one element from Object for each element from list, when IN gives me all elements.

for( String element: list) {
 Select id  from Object Where  field = (Select field2 from Object2 where id = element)
}