Question using set_relation

Hi,

my Tabel Strukture looks like this (simplified)



Event

Id, Title, DepartmentId



Departments

Id, Name, UniversityId



Universitys

Id, Name

in the Event View i want to join Departmens and Universitys in one Column so it looks like

Events
Title | Departments
'Animals' | ' Biology @ Yale'

Something like this in the set_relation





$crud->set_table('Events');

$crud->display_as('DepartmentId','Department');



$crud->set_relation('DepartmentId','Departments','{Name}, {SELECT Name JOIN Universitys ON UniversityId}');

how can this be done ?

Greetings

Georg Ha