table 1
table 2
Expected result is :
table 3:
actgeneric_id------- fNotam_id
1.2.1.1.3.1 ---------- 1.2.1.1.3
1.2.1.1.3.5.1----------1.2.1.1.3
1.2.1.1.3.5.2----------1.2.1.1.3
....
....
.....
.....
1.2.1.1.4.1------------1.2.1.1.4
1.2.1.1.4.2------------1.2.1.1.4
......
......
Actually, these are xml_id hieararcy for creating the relational database tables.
You could use an InlineQuerier to do this,
e.g.
SELECT aa."actgeneric_id", bb."notam_id"
FROM Table1 aa, Table2 bb
where aa."actgeneric_id" like bb."notam_id"||'%'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.