markquee
(Markjohn42)
July 14, 2013, 11:31pm
1
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
jayant
(Codesutras)
July 15, 2013, 4:21am
2
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
markquee
(Markjohn42)
July 15, 2013, 5:30am
3
simple just add specific theme in the tbl_dept that group by.