Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_39 (astc_member VARCHAR, aam_accredited VARCHAR, state VARCHAR, aam_member VARCHAR)

### Question ###
What is ASTC Member, when State is Arkansas, when AAM Member is No, and when AAM Accredited is Yes?

### Accurate SQL ###

SELECT astc_member FROM table_name_39 WHERE state = "arkansas" AND aam_member = "no" AND aam_accredited = "yes"