SQL query where in

[eluser]Cosai[/eluser]
Hi,

I am newbie to CI. It seems a nice one but I have a question.

I have seen the where_in function but it searches an array so considering a query like below

Select * from users where friend_id in (select * from vip where salary<1000)

Select the users who are friends with the VIP's whose salary is less than 1000 ???

Do I have to make two queries for that query to use where_in function?

Cosai