Code: Select all
SELECT "Query_MassMurder"."ID" AS "ID", "Query_MassMurder"."month" AS "month", "Query_MassMurder"."date" AS "date", "Query_MassMurder"."year" AS "year", "Query_MassMurder"."city" AS "city", "Query_MassMurder"."state" AS "state", "Query_MassMurder"."dead victim count" AS "dead victim count", "Query_MassMurder"."undead victim count" AS "undead victim count", "Query_MassMurder"."suicide?" AS "suicide?", "Query_MassMurder"."UNKNOWN" AS "UNKNOWN", "Query_MassMurder"."AX" AS "AX", "Query_MassMurder"."HATCHET" AS "HATCHET", "Query_MassMurder"."KNIFE" AS "KNIFE", "Query_MassMurder"."OTHER SHARP" AS "OTHER SHARP", "Query_MassMurder"."BLUNT" AS "BLUNT", "Query_MassMurder"."EXPLOSIVE" AS "EXPLOSIVE", "Query_MassMurder"."POISON" AS "POISON", "Query_MassMurder"."STRANGLE" AS "STRANGLE", "Query_MassMurder"."DROWN" AS "DROWN", "Query_MassMurder"."ARSON" AS "ARSON", "Query_MassMurder"."HANG" AS "HANG", "Query_MassMurder"."OTHER" AS "OTHER", "Query_MassMurder"."FIREARM (unidentified)" AS "FIREARM (unidentified)", "Query_MassMurder"."shotgun" AS "shotgun", "Query_MassMurder"."rifle" AS "rifle", "Query_MassMurder"."pistol" AS "pistol", "Query_MassMurder"."machine gun" AS "machine gun", "Query_MassMurder"."cause" AS "cause", "Query_MassMurder"."category" AS "category" FROM "Query_MassMurder" "Query_MassMurder"
Code: Select all
WHERE "QueryMassMurder"."year" = 1911
Thanks, that fixed it. Now, if I just get booleans to test. TRUE 'TRUE', or 'T'?