SELECT a.topicid, a.periodid, b.topicTitle, c.periodName FROM myTable a INNER JOIN topic b ON a.topicid = b.topicid INNER JOIN period c ON a.periodid = c.periodid;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)