...
/Solution Review: Write a Generalized Query
Solution Review: Write a Generalized Query
Let's review the solution to the previous challenge.
We'll cover the following...
Solution: a nested query querying person
SELECT CreatedTimestamp, BodyFROM journal_entriesWHERE PersonId =(SELECT PersonIdFROM personWHERE FirstName = "Frankie" AND LastName = "Manning");
Explanation
Let’s take a look at what makes up this SQL statement. We’ve already seen the first 3 lines in the ...