ms access courses in london - Subquery?

Hi Sabrina

Basically a subquery is query inside a query. If you want to write the SQL for this yourself, you can go into SQL view within the query. The code you need will be something very similar to this:

SELECT * FROM Yourtab1 WHERE YourName IN (SELECT YourName FROM Yourtab2 WHERE Yourtab2.SurnameName=Yourtab1.SurnameName);

Hope this helps

David