Join table query in hook_views_query_alter not selecting field from joined table
There a typo in your SQL query: instead of 

field_data_field_gm_tanknummer.field_data_field_gm_tanknummer_value


you need to specfiy:

field_data_field_gm_tanknummer.field_gm_tanknummer_value