只要将这个表连结两次。完成之后,你就必须使用表别名:
1) 将要显示的字段用表的别名区分,
2 ) 连接表的时候用表的表名,连接表
SELECT a.Parent_ID
, bp.Name AS Parent_Name
, a.Child_ID
, bc.Name AS Child_Name
FROM TableA AS a
INNER JOIN TableB AS bp
ON bp.ID = a.Parent_ID
INNER JOIN TableB AS bc
ON bc.ID = a.Child_ID