join multiple tables to calculate with fields + percentiles

[#1]

Hi,

I have 3 tables:

Table1:
ORDERNR,
REVTS

Table2:
ORDERNR,
SPECNR

Table3:
SPECNR,
EXTS

To calculate the run time of the proces i do EXTS - REVTS but i want to do it in script... how do i join the tables to a table4 do make the calculated field and drop the table? Also i need to give a list of the run time values greater than P95... can i use if((runtime>fractile(runtime,0.95)), runtime, null())??

thx

[#2]

Hi,

The sintax of query is diferent for a diferents datebases (is not the same for Sql Server or Oracle) so, if you import data from database can you say the tipe?.

Thanks.

[#3]

qvd's from an oracle db 🙂