Regarding the plus sign way, you just put the plus sign on the key from the table that might be missing the record. In your example, it would be:
SELECT d.Child_ID, D1."Date", d2.Goal_ID, d2."Hour", d2.Score, d."Last_Name"+", "+d."First_Name"+" - "+d.Child_ID as SName
FROM "Children.db" d...