Scripting

[Anonymous]

Hi

i am having some trouble doing the following: I have imported some qvd files that have automatically linked in outer join. What i need to do now is to create a table, that i will need to store as qvd, that bings togheter fields from the differen tables.

How do i do this? I don't understand which is my 'from statement'.

tx

[fkeuroglian]

Hi Niccolo, you wil have to use Resident and join or concatenate the tables bring from qvd

example

TABLE1:

load A,B,C from qvd1

TABLE2:

load A,X,Z from qvd2

newtable

load A,B,C

resident TABLE1;

left join

load A,X,Z

resident TABLE2;

good luck

Fernando