Because I like Visual explanations, have a read of this;
Google Image Result for http://www.fetoon.net/images/depth_of_field.jpg
Printable View
Because I like Visual explanations, have a read of this;
Google Image Result for http://www.fetoon.net/images/depth_of_field.jpg
As you have probably gathered from the (helpful) replies and the linked articles, because depth of field increases as the distance increases, the answer is:
Even with your aperture open all the way, you will need a very long focal length to get a narrow depth of field.
Then the problem arises that generally long focal length lenses don't have particularly large maximum apertures.
So the best you can do is use your longest lens and your largest aperture. If you have some very expensive lenses you will be able to get what you described.