Concatenating FROM clause

I have a need to combine the FROM and WHERE clauses from one SQL into a new SQL that I am generating in my trigger. I am having some difficulty performing the concatenation. Essentially, I am trying to do the following:
...

sTmp := ' TABLEA A, TABLEB B WHERE A.COL5 = B.COL6;'
...

INSERT INTO MYTABLE SELECT MY_ALIAS.COL1 FROM TABLEA MY_ALIAS, || sTmp

Is it possible to do such concatenations or is there a better approach for this task?

Thanks.

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 16 2001 - 22:12:22 CST