select * from programmers p, birth_certificates bcwhere p.language = 'RUST'and p.gender = bc.genderand p.person_id = bc.person_idguy's what's wrong with my query? for some reason it's not returning any rows
select * from programmers p, birth_certificates bcwhere p.language = 'RUST'and p.gender = bc.genderand p.person_id = bc.person_id
>>108774475>for some reason it's not returning any rowsjoin with table deleted_programmers
forgot to change connection string from jdbc:postgresql:tired_tropes to jdbc:postgresql:real_world
>>108774475did you try debugging with socks on?
>>108774475Look into SQL joins: https://www.w3schools.com/sql/sql_join.asp
>>108776506He's using an implicit join.
>>108774475Don’t worry anon I got the joke. It wasn’t that good of a joke but I got it
>>108775044then there would be no rows with language = RUST in the first place