Tag: ###sql

SQLite Question – SELECT WHERE IN #sql

Here’s a pretty dumb question. Why will the following extremely simple query not return the desired results? I’m trying to see the sentence templates just for the birth, death, marriage, and burial facts. SELECT FT.FactTypeID, FT.Name, FT.Sentence FROM FactTypeTable AS FT WHERE FT.Name IN (‘Birth’,’Death’,’Marriage’,’Burial’); To get the desired results, I instead do something like…

Read the full article