[eluser]Unknown[/eluser]
Hi guys...
I'm kinda new to the CI world....
I'm currently working on a project where all the queries are created using the ActiveRecord Class.
I find AR very easy to use.... nevertheless I've been needing to excecute this particular query wich I have no clue on how to build using ActiveRecord.
the query is:
SELECT productId, name, description, status
FROM products
WHERE vendorId in (SELECT vendorId
FROM vendors
WHERE customerId = $customer_id)
Thanks for your help.