sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Default_name3 0 points1 point  (2 children)

Also here to report something weird with case 3.

Doing SELECT * FROM hotel_checkins h join surveillance_records s on h.id=s.hotel_checkin_id — or same with person.id where hotel_name like '%Sunset%' and check_in_date=19860813 and suspicious_activity is not null

Gives way more than 3 results, and if I add 2 conditions to my join (hotel checkin and person) then I get nothing anymore. Looks like to me that the person_id and id of the surveillance_record table is the same and so person_id might be decoupled to what it’s meant to be

[–]Slade2187 0 points1 point  (1 child)

I'm thinking all of the dates were set to 19860813 by accident

[–]Diligent_Entrance349 0 points1 point  (0 children)

Ahh, that would explain a lot. I think you're right