How to query in SQL using list from JSL

[#1]

Hi all, 

How can I insert a list from JSL to my SQL query?

Currently I am using this to get the list that I need:

NameList = Associative array( dtNames:"Names" ) << Get Keys; 

And will use it as a SQL query

dt = Open Database( "DSN=db;UID=uname;PWD=pw;APP=JMP;DATABASE=dbname;", 
"select name, age, address, sex
from  db_Details
where name in ('"||NameList||"')", // Im getting an error here
"Details" );

I am using JMP 15

[#2]

I do this a lot for creating SQL queries.  Try this.

NameList = Substitute( Char( NameList ), "{", "", "}", "", "\!"", "'" );

[#3]

See an additional Discussion item intitled How to skip item on JSL list in SQL query if it does not exist?