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.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql
index e40cba9..7739ad4 100644
--- a/wk7/pset/fiftyville/log.sql
+++ b/wk7/pset/fiftyville/log.sql
@@ -202,8 +202,8 @@ WHERE phone_number IN (
SELECT name
FROM people
JOIN phone ON people.phone_number = phone.phone_number
-JOIN phone ON people.phone_number = phone.phone_number
-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
SELECT name