Join inside a wpdb query.. confused!

$emailusers = $wpdb->get_results(
    "SELECT p.ID AS post_id, p.post-title, u.user_email " .
    "FROM $wpdb->posts AS p " .
    "INNER JOIN $wpdb->users AS u ON p.post_author = u.ID " .
    "WHERE p.post_type="sales" AND HOUR( TIMEDIFF( NOW( ) , p.post_date_gmt ) ) >=1)"
);

foreach ($emailusers as $user) {
    // do wp_mail stuff from here

    // $emailusers->post_title;
    // $emailusers->user_email;

    // used 'post_id' alias rather than 'ID' so it's clear it's not the author ID
    // $emailusers->post_id;
}