From de6980860b012fd2dfd1f7a77b47473ff290dc4f Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Mon, 30 Dec 2019 22:27:46 -0500 Subject: Join with USING wherever possible --- database.h | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database.h') diff --git a/database.h b/database.h index 1837a9f..d02bc28 100644 --- a/database.h +++ b/database.h @@ -266,7 +266,7 @@ static const char *InitSQL = SQL( nick, user, target, message FROM events JOIN contexts USING (context) - JOIN names ON names.name = events.name; + JOIN names USING (name); CREATE VIRTUAL TABLE search USING fts5 ( network, channel, query, nick, user, target, message, -- cgit 1.4.1