Wordpress make own queries??

Question

How to make a simple query with wp like

 $qry = "SELECT id, name FROM soccer_team_members ORDER BY id ASC";
 $teams= $wpdb->get_results( $qry , ARRAY_A);

that didn't work but this does

    $qry = "SELECT id, event_name, event_link, event_loc, event_desc,
    event_start_time, event_end_time FROM wp_wplistcal 
    ORDER BY event_start_time ASC";

$events= $wpdb->get_results( $qry , ARRAY_A);

even when i rewrite the table to wp_soccer_team_members it doesn't work???