db02 өчен SQL-сорау җибәрү синтаксисы

    select o~matnr, o~sernr, e~equnr, e~objnr up to 100 rows
      from objk as o
        inner join equi as e on e~equnr = o~equnr
        inner join jest as j on j~objnr = e~objnr
      where o~matnr = '000000000000065035'
        and j~stat  = 'I0184'
        and j~inact = ''
        and o~taser = 'SER03'
        and o~equnr not in (
          select o0~equnr
            from objk as o0
              inner join equi as e0 on e0~equnr = o0~equnr
              inner join jest as j0 on j0~objnr = e0~objnr
            where
              j0~stat <> 'I0184'
              and o0~taser = 'SER03'
              and o0~equnr = o~equnr
              and j0~inact = '') " group by o~matnr, o~sernr, e~equnr, e~objnr  
              order by o~sernr.

select o.matnr, o.sernr, e.equnr, e.objnr
from objk as o 
inner join equi as e on e.equnr = o.equnr
inner join jest as j on j.objnr = e.objnr
where o.matnr = '000000000000065035' and j.stat = 'I0184'
  and j.inact = ''
  and o.taser = 'SER03'
and o.equnr not in ( select o0.equnr from objk as o0
              inner join equi as e0 on e0.equnr = o0.equnr
              inner join jest as j0 on j0.objnr = e0.objnr
            where
              j0.stat <> 'I0184'
              and o0.taser = 'SER03'
              and o0.matnr = '000000000000065035'
              and o0.equnr = o.equnr
              and j0.inact = '') group by o.matnr, o.sernr /* , e.equnr, e.objnr */
 order by o.sernr limit 100