From 51f5977cb96fd896fc0beafb07a76b7d4b115a77 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 08:35:58 +0000
Subject: Tue, May 21, 2024, 1:35 AM -07:00

---
 wk7/pset/fiftyville/log.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'wk7/pset')

diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index 7739ad4..0ff4b83 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -203,7 +203,8 @@ SELECT name
 FROM people
 JOIN phone ON people.phone_number = phone.phone_number
 JOIN passengers ON people.passport_number = passengers.passport_number
-JOIN bakery_security_logs ON people.phone_number = phone.phone_number
+JOIN bakery_security_logs ON people.license_plate = bakery_security_logs.license_plate
+WHERE
 
 
 SELECT name
-- 
cgit v1.2.3