load fields from two .qvd file

[#1]

Hi,
How can I select fields from two .qvd file? I have used Qualify statement to join fields in different tables, but sometimes it is not enough. Here is simply SQL statement example what I mean.

Directory;

LOAD ID,

FIRSTNAME,

LASTNAME

FROM Customer.qvd (qvd);

Directory;

LOAD ID,

STREETNAME,

CITY,

COUNTRY

FROM Address.qvd (qvd);

With SQL

SELECT c.firstname, c.lastname, a.city
FROM Customer c
JOIN Address a ON c.id=a.id

[Anonymous]

hi jaana ,when you load the fields in edit script first you should name the tableas you like(in your's appl directory)then you can save the script(cntrl+s)>>run the edit script(cntrl+e)>>here you will get the fields you are loaded.

[#3]

I try to ask, can I load data like this (syntax is not correct)? If I can -> please, tell me correct syntax!

LOAD

FIRSTNAME,

LASTNAME,

CITY

SELECT c.firstname as FIRSTNAME,

c.lastname AS LASTNAME,

a.city AS CITY

FROM Customer.qvd (qvd);

JOIN Address.qvd (qvd) ON c.id=a.id;

[Anonymous]

Hi, you should be able to do something like this:

TEMP:
LOAD ID,
FIRSTNAME,
LASTNAME
FROM Customer.qvd (qvd);

JOIN (TEMP)
LOAD ID,
STREETNAME,
CITY,
COUNTRY
FROM Address.qvd (qvd);

TABLE_NAME:
Load
FIRSTNAME,
LASTNAME,
CITY
Resident TEMP;

Drop table TEMP;