You can't query multiple containers in a single query in cosmos. The best way to do this without writing any client code is to merge the data in those 2 collections and differentiate each entity by some attribute like type . Then you can write a stored procedure.