CodeIgniter Forums
Query Builder and subqueries - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: Query Builder and subqueries (/thread-65031.html)



Query Builder and subqueries - ofry - 04-21-2016

Hello.

Can you add support subqueries in where_in(), where_not_in(), or_where_in(), or_where_not_in() statements?

For sample,


Code:
"lot"."Lot_ID"   in (select "lot_id" from "hwc_data"."dbo"."lotspec")

(Microsoft SQL Server).