From ffde713ff3b6489c30b7416f448f6e6c6c273ac1 Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Tue, 21 May 2024 08:34:57 +0000 Subject: Tue, May 21, 2024, 1:34 AM -07:00 --- wk7/pset/fiftyville/log.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'wk7/pset') 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 -- cgit v1.2.3