I'm not very expert with calibre's search language. Do you mean you have 2 or more entries in the library which should all have been entered under one book.
The relevant bit of the
manual is here but it may not cover the complexities you need. If you don't get any responses here, it might be worth opening a new thread specifically asking for help with Search and specifying exactly what you're trying to do.