summary refs log tree commit diff
path: root/litterbox.c
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-30 22:27:46 -0500
committerJune McEnroe <june@causal.agency>2019-12-30 22:29:08 -0500
commitde6980860b012fd2dfd1f7a77b47473ff290dc4f (patch)
treebbd46f89d2ccd120c28c7f941e6c9a97a8fe8c01 /litterbox.c
parentAdd -D flag to prospective scoop manual (diff)
downloadlitterbox-de6980860b012fd2dfd1f7a77b47473ff290dc4f.tar.gz
litterbox-de6980860b012fd2dfd1f7a77b47473ff290dc4f.zip
Join with USING wherever possible
Diffstat (limited to 'litterbox.c')
-rw-r--r--litterbox.c4
1 files changed, 2 insertions, 2 deletions
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)