Probably, you need to use a JOIN: SQL Joins
If you have two tables Authors:
1 Terry Pratchett
2 David Eddings
ID AuthorId Name
1 1 Night Watch
2 1 Thief of Time
3 2 Demon Lord of Karanda
And you want to retrieve author and books:
a.[Name] AS Author,
b.[Name] AS Title
FROM Authors a
JOIN Books b
Then you will get:
ID Author Title
1 Terry Pratchett Night Watch
1 Terry Pratchett Thief of Time
2 David Eddings Demon Lord of Karanda
Your description isn't very clear on exactly what you are trying to achieve, but that should enable you to work it out.
You can use a WHERE clause that involves both tables.
... WHERE a.Name LIKE 'Terry%' AND b.Name LIKE '%Time'