How to build SQL query for associated values?

I am using PyODBC to fetch some data, since I am not fetching all data in my table, I need to write a query which grabs only rows which have associated columns. For example my initial query is """SELECT SRNumber FROM SO_SC_1 WHERE SRNumber LIKE '%1-%""". This returns the SRNumber values that I want, next I want to return the associated last edited user with this SRNumber, this column is named last_edited_user what is the proper syntax to incorporate multiple queries into one for this scenario? Basically I would like to use the initial query and grab all associated data for each SRNumber.