But now for the advanced and important stuff: How can we modify it to also pull the same from the table “girls” in a single query? I like SQL efficiency and inclusivity, and I’m sure half of all dogs agree. (Well, according to my research, all dogs like inclusivity, but only 50% likes SQL efficiency)
I think you could also do:
SELECT name FROM boys WHERE good;But now for the advanced and important stuff: How can we modify it to also pull the same from the table “girls” in a single query? I like SQL efficiency and inclusivity, and I’m sure half of all dogs agree. (Well, according to my research, all dogs like inclusivity, but only 50% likes SQL efficiency)
A better database design would have been to name the table
dogsand add a column to indicate whether the dog is aboyor agirl, maybe with enums