I have the following code to retrieve and display the first and last names of writers who are also editors (ED\_ID = WRT\_ID).

```
SELECT Writers.WRT_LastName AS LastName, Writers.WRT_FirstName AS FirstName
FROM Writers INNER JOIN Editors ON Editors.ED_ID = Writers.WRT_ID;

```

It produces the results I want, but how would I write it using a subquery and produce the same results?

I am using Access 2013

Let me know if I need to provide more info.