AnsweredAssumed Answered

ExecuteSQL beginner

Question asked by mjharding on Jun 5, 2018
Latest reply on Jun 6, 2018 by beverly

Hi

 

SQL noooob here.

 

I started with what I thought was the easiest ExecuteSQL script possible, but I still get a "?"

From my JOBS table I am trying to get the email of Bob Smith in my PEOPLE table.

 

ExecuteSQL (

"SELECT email

FROM PEOPLE

WHERE name_full = bob smith"

; "" ; "" )

 

If I remove the WHERE statement I successfully get all emails, but with it in I get "?"

I have also tried WHERE name_last = smith with no luck.

 

Thanks

Outcomes