Query is too complex

[badger8]

I was doing a query to find all contacts that are from a list of accounts. There is around 30 accounts that I'm looking for contacts that are from these accounts.

I keep getting "Query is too complex". WHy? Need help asap.

Thank you

 

[Aivars]

Use instruction In in your query Where clause, e.g.:

Select * From MyTable Where Account In(2,5,78,100,23);

Aivars