select item from items where item in
(select item from item_skj is,item_sku iku ,datestat dt
where is.cost=iku.cost
and is.dates=dt.datess+1)
and supplier  is  null;

SELECT count(*)
FROM   (select item 
        from   items 
        where  item in (select item 
                        from   item_skj is
                              ,item_sku iku 
                              ,datestat dt
                        where  is.cost=iku.cost
                        and    is.dates=dt.datess+1)
         and    supplier is null)

ITEM    COST     DATESS 
___________________________
5678432  2300     jun1808
5678432  4300     jun0908
5678432  3278     jui0808
123456
123456
3211222
3211222
123214
32453
...
Like ths am gettomg 3000 rows.