From bf8d0cbdbe3f16eaa59cf25c05cbbe35a8a72cfa Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Tue, 21 May 2024 08:40:11 +0000 Subject: Tue, May 21, 2024, 1:40 AM -07:00 --- wk7/pset/fiftyville/log.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'wk7/pset/fiftyville/log.sql') diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 0e7a840..370b13c 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -201,7 +201,7 @@ WHERE phone_number IN ( SELECT name FROM people -JOIN phone ON people.phone_number = phone_calls.phone_number +JOIN phone_calls ON people.phone_number = phone_calls.phone_number JOIN passengers ON people.passport_number = passengers.passport_number JOIN bakery_security_logs ON people.license_plate = bakery_security_logs.license_plate WHERE year = 2023 -- cgit v1.2.3