From de6980860b012fd2dfd1f7a77b47473ff290dc4f Mon Sep 17 00:00:00 2001
From: "C. McEnroe" <june@causal.agency>
Date: Mon, 30 Dec 2019 22:27:46 -0500
Subject: Join with USING wherever possible

---
 litterbox.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'litterbox.c')

diff --git a/litterbox.c b/litterbox.c
index af531ff..2ab2bf1 100644
--- a/litterbox.c
+++ b/litterbox.c
@@ -219,8 +219,8 @@ static void querySearch(struct Message *msg) {
 				highlight(search, 6, :bold, :bold),
 				events.event
 			FROM events
-			JOIN contexts ON contexts.context = events.context
-			JOIN names ON names.name = events.name
+			JOIN contexts USING (context)
+			JOIN names USING (name)
 			JOIN search ON search.rowid = events.event
 			WHERE contexts.network = :network
 				AND coalesce(contexts.query = :query, true)
-- 
cgit 1.4.1