diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:35:58 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 08:35:58 +0000 |
| commit | 51f5977cb96fd896fc0beafb07a76b7d4b115a77 (patch) | |
| tree | 0a16c5ff4d080c29358a8e0dab5ce7d00eabff2d /wk7/pset/fiftyville/log.sql | |
| parent | ffde713ff3b6489c30b7416f448f6e6c6c273ac1 (diff) | |
Tue, May 21, 2024, 1:35 AM -07:00
Diffstat (limited to 'wk7/pset/fiftyville/log.sql')
| -rw-r--r-- | wk7/pset/fiftyville/log.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/wk7/pset/fiftyville/log.sql b/wk7/pset/fiftyville/log.sql index 7739ad4..0ff4b83 100644 --- a/wk7/pset/fiftyville/log.sql +++ b/wk7/pset/fiftyville/log.sql @@ -203,7 +203,8 @@ SELECT name FROM people 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 +JOIN bakery_security_logs ON people.license_plate = bakery_security_logs.license_plate +WHERE SELECT name |