select Type_Name,t_Activity.*
from
t_ActivityType inner join t_Activity on t_ActivityType.Type_ID=t_Activity.Act_Type
from
t_ActivityType inner join t_Activity on t_ActivityType.Type_ID=t_Activity.Act_Type
调试欢乐多
输出 id--name