wp_posts query various Custom post types into report wordpress
<p>I have <code>CPT cars</code> and <code>CPT Event</code> class which the cars are racing in.</p>

<p>I need to be able to do up a report for an event (race)  I need to be able to display the personal details of the person, Car details and event class entered into.  This information is all stored in the <code>wp_posts</code> table and the <code>wp_postmeta</code> table.  They are all linked by the <code>post_id</code> and en example of the <code>meta_values</code> is <code>wpcf-car-type</code>, <code>wpcf-cc</code>, <code>wpcf-aspiration-type</code>  etc..
How can I query all this information into one report ?</p>