This will work fine.
global $wpdb;
$querydetails = "
SELECT
wposts.*
FROM
$wpdb->posts AS wposts
INNER JOIN
$wpdb->postmeta AS wpostmeta ON wposts.ID = wpostmeta.post_id
WHERE
wposts.post_status="publish"
AND wposts.post_type="match_report"
AND wpostmeta.meta_key = 'report_home-select'
AND wpostmeta.meta_value="198"
";
$teaminfo = $wpdb->get_results($querydetails, OBJECT);
Try it.