从使用SQL获取主表中只有id的不同表中的名称？

I have 4 table used to fill combo boxes having id and name and their id's saved in main table now I have tables like:I have 4 table used to fill combo boxes having