This seems like a fairly simple join, so I'm going to assume you aren't familiar with joins. To join two tables, you need to connect them based upon a common value. In this case, the TechnologyId field contains the values that are equal (the number represents a row in the TechnologyMaster table). Now we need to make an assumption: do we want all the records from one table and the values from the other table that match or do we want only the rows that match on both sides. For instance, if we have a record in the TechnologyMaster table that doesn't have a corresponding row (or rows) in the Title Master table, do we want that row from TechnologyMaster to show? The same is true in reverse (although it is less likely since the TitleMaster table seems to be dependent on the TechnologyMaster table). I will assume we want the rows where there is a match on both sides. This is called an INNER JOIN and it is the most common type of join. Here is how we would do this:
SELECT te.TechnologyName, ti.ProjectTitle
FROM TechnoloogyMaster te
INNER JOIN TitleMaster ti ON te.TechnologyId = ti.TechnologyId
Note that I renamed the tables to make them shorter (te instead of TechnologyMaster and ti instead of TitleMaster). This is just to simplify things.