In my calendar List I have a dbjoin (steward tbl) element with the following condition which is working fine.
where {thistable}.Region IN(SELECT Region FROM steward WHERE J_id = '{$my->id}' OR {thistable}.Region ='ALL') AND {thistable}.active =1
I have another dbjoin (club tbl) and I require a similar condition so only the club names with the same region as the logged in user are displayed.
I have played around trying different options but no luck with my SQL skills
Thanks
Steve
where {thistable}.Region IN(SELECT Region FROM steward WHERE J_id = '{$my->id}' OR {thistable}.Region ='ALL') AND {thistable}.active =1
I have another dbjoin (club tbl) and I require a similar condition so only the club names with the same region as the logged in user are displayed.
I have played around trying different options but no luck with my SQL skills
Thanks
Steve