Yep, it’s me, puzzled again
For this exercise I need to list posts, but only for active users. My code doesn’t exactly match what’s being sought, but I believe that I have the code that the program expects, which hinges on the JOIN between the posts.user_id and users.id fields.
I sorted on username to bring the interesting posts to the top of my results. The top 6 results (posts) have an ID that exist in both tables, which is why they were found, but the username/email are both NULL. So, my question is whether the existence of an ID in the users table is enough to confirm that the user is active. Or, do the NULL values for both username and email suggest that the user is inactive, despite the existence of the ID?