Little help on Join if you have a moment?

[eluser]internut[/eluser]
Yeah after you stating that duh. Eventually i figured out i need to go the two way route. I need to try your suggestions within some code. My eyes are closing. If you can check up on this thread as things never go as I want them to. Thanks kgill

[eluser]internut[/eluser]
ok so i'm 99% of the way there on this join.

the code below is doing a search on the [groups_exp] table "id" field rather then the [users] "id" field.

Code at this time:

Code:

$data['query']   = $this->db->query("SELECT * FROM `users` WHERE `id` IN (SELECT `user_id` FROM `groups_exp` WHERE `group_id`='$filter_group' AND status='$user_status' AND $field LIKE '$keyword') ORDER BY $sort $direction LIMIT $start,$config[per_page] ");     // query time

Any thoughts? Why is it searching the [groups_exp] id field and NOT searching it and not the [users] "id" field