You can't from that little information, as there is no information which ties the three tables together. If you have an ID which refers to the other tables, or which is common to all three, then you can:
SELECT a.Name + b.Name + c.Name FROM FirstTable a
JOIN SecondTable b ON a.ID=b.ID
JOIN ThirdTable c ON a.ID=c.ID