很难从4个表中获得数据

I have four tables in my DB - one, called kursplan, 2nd table is kursplan_kurse,3rd table is kursplan_kursraum 4th table is kursplan_trainer.I have four tables in my DB - one, called kursp