How many times can you spot the letter y in:
Q: Query not working I want to see all emails sent to a specific subscriber
I have created a DE with the field subscriberKey is only and primary key
I then want to set up an Query Activity based on the Query
SELECT j.EmailName, s.EmailAddress from  _Job j 
INNER JOIN _Sent se on j.JobID = se.JobID
INNER JOIN _Subscribers s ON se.SubscriberKey = s.SubscriberKey
WHERE se.EventDate < GetDate()

However as the subscriberKey is required within my Target DE I get this error message when I want to save the Query

A problem occurred creating your query definition. Please contact Customer Service for additional information.
  Name: Email sent to spec individual 
  External Key: a7fc18e8-051d-4f53-8d98-5bf73b0dc6f8
  Error saving the Query field.Field SubscriberKey is a required for the Target Data Extension. Ensure this field is specified in your query text.

Where do I enter the subscriberKey for the specific individual in the query text?

A: You need to also select the susbcriberkey in your query or make it not required.
Try this:
SELECT 
s.SubscriberKey
,s.EmailAddress as Email
,j.EmailName
,s.EmailAddress from  _Job j 
INNER JOIN _Sent se on j.JobID = se.JobID
INNER JOIN _Subscribers s ON se.SubscriberKey = s.SubscriberKey
WHERE se.EventDate < GetDate()


user
The total number of "y"s in that passage is 30.
assistant