summaryrefslogtreecommitdiff
path: root/wk7/pset/fiftyville/log.sql
diff options
context:
space:
mode:
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
-rw-r--r--wk7/pset/fiftyville/log.sql2
1 files changed, 1 insertions, 1 deletions
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