visa nupastinus cia chaosas gautusi :)
cia vienas sakinys, naudojantis duomenis is 3 lentu - table_A, table_B, 
table_C

with query_1 as
(select ... from mirror.table_B)
select
  col_1,
  ...
  col_N,
  ...
from table_A, table_B, table_C
where ....
UNION ALL
select
  col_1,
  ...
  (select col_x from query_1 where ...) col_N
  ...
from table_A, table_B, table_C
where ...
order by ...


"tallman" <bill.tallman@gmailas.com> wrote in message 
news:i5ocev$6up$1@trimpas.omnitel.net...
> nelabai aiski situacija.
> is selecto matosi kad is mirror schemos (per dblinka) selectini tik is 
> table_B,
> o apacioj rasai kad jeigu mirror.table_A eis ne per dblinka viskas ok...
>
> zodziu nupastink visa selecta, nes biski neaisku...