The practical example, outlined below, demonstrates a process of selecting all posts with a particular Custom Field value stored, and displaying them in a Page based on a Page Template.
http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query