diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:34:57 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:34:57 +0000 |
| commit | ffde713ff3b6489c30b7416f448f6e6c6c273ac1 (patch) | |
| tree | d87aedb37ae3c821f3722775d939eaef37d26b02 /wk7/pset/fiftyville | |
| parent | 06867e8898ae888438bae43c08c1f5d04ed5e0ce (diff) | |
Tue, May 21, 2024, 1:34 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 4 |
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 |