summaryrefslogtreecommitdiff
path: root/wk7/pset/fiftyville/log.sql
diff options
context:
space:
mode:
authorFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-21 08:40:11 +0000
committerFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-21 08:40:11 +0000
commitbf8d0cbdbe3f16eaa59cf25c05cbbe35a8a72cfa (patch)
tree504318fd6979f1b13118cde29f86447d089e8106 /wk7/pset/fiftyville/log.sql
parent53d80f12df73568cd26de28f4f13e4661f247b4d (diff)
Tue, May 21, 2024, 1:40 AM -07:00
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