I need to convert the following SQL Query to LLBLGen Code.
select count(1) from stock s
where s.item_code in
(
select distinct s.item_code from stock s left join STK_ANALYSIS a
on s.item_code=a.item_code
where a.analysis_code='TEST'
) ;
how can i do it?
