SELECT
a.ID,
a.Col1,
b.Col2,
c.Col3
FROM
TableA AS a
INNER JOIN TableB AS b ON a.ID = b.ID
INNER JOIN TableC AS c ON a.ID = c.ID;
There is one thing about the query above that may (or may not) be a problem for you. An Id must be present in all three tables for it to be returned in the results. If you have the situation where one or more tables do not have an Id and you still want to get the results, you will need to change the joins to a LEFT/RIGHT/FULL as the case may be.