I have two tables:
1) Users
2) Trustmembers
I want to take all userId's from Trustmembers and compare with Id of Users table and then i want to print all the names from Users table of matching id's.
In sql I can write the query like
select name from users where Id IN(select userId from Trustmembers);
How to write the same query in Model(MVC) of php codeigniter to get the same result?
Or any other way except using Where_in??