Dif. Themes In Selected Id

hi i have lets say i have tbl_dept and the dept column was group by. Now the other tbl_theme list all my theme for specific dept.

heres my table

======================================================================

tbl_dept || tbl_theme

======================================================================

id | dept || id | theme_user | theme

1 deptA 1 deptA themeB

2 deptA 2 deptC themeA

3 deptB 3 deptB themeB

4 deptC 4 deptD themeC

5 deptA 5 mytheme theme_mytheme

6 deptB 6

…

if you gruop the dept is should be

1-deptA

3-deptB

4-deptC

now if i view the the id of 2 in tbl_dept the theme should be theme_mytheme

and if i view the id in 1 the theme should be themeB, in id 3 theme should be themeB

Didn’t understand this.Could you please explain a bit more clearly.What you are doing now and what you want to achieve?

now if i view the the id of 2 in tbl_dept the theme should be theme_mytheme

and if i view the id in 1 the theme should be themeB, in id 3 theme should be themeB

simple just add specific theme in the tbl_dept that group by.