Below are my two tables :
I am trying to write a query that joins these 2 tables AND returns the Source_Title and Destination_Title for the given Source ID of Result Map table.
I have tried written the query, but I can only solve one part of the puzzle not the whole thing.
SELECT Title as SourceTitle
FROM Result Map AS RM
INNER JOIN Table_Result TR ON RM.SourceId = TR.Id
The above query gives me the title for the source, but not the Destination title.