insert into outcdswithtitle select streamtopcds.*, cdtitle.* from streamtopcds, (database "myoracle" schema (cdtitle string) [[ select cdtitle from cd where year = ?streamtopcds.myyear ]] ) as cdtitle ;


insert into outtrades select firsttrade.* from intrades as firsttrade, intrades as secondtrade, intrades as thirdtrade, intrades as fourthtrade matching once [1 second: firsttrade, (secondtrade && thirdtrade) && !fourthtrade] on firsttrade.symbol = secondtrade.symbol = thirdtrade.symbol = fourthtrade.symbol where firsttrade.price < secondtrade.price and firsttrade.price < thirdtrade.price and firsttrade.price > 1.05*fourthtrade.price;