i can't do a join

[magdagarcia]

when i try to do a join appear the next error;

for example;

table_name_X:

LOAD

field1 as fiedtojoin,

field2,

field3

from table1

outer join

LOAD

field1 as fiedtojoin,

field3,

field4

from table1

store table_name_X INSERT table_name_store.qvd

ERROR:

no found the table called: table_name_X

BUT when i disable the sentence: //store table_name_X INSERT table_name_store.qvd

work it

Some Any IDEA??

Regards!!!

[alexandros17]

If I'm not wrong the sysntax is

Store Table INTO .....

[#3]

Your store stament is wrong. use store like below.

STORE MyTableName into            $(Directory)$(vMyTableName).qvd;

[magdagarcia]

Hi KStrak S  and alexandros17good moorning thanks for you response but the query Actually is done on this way:

BUT THANKS VERY MUCH FOR YOUR HELP!!!

GPS_Quotes_Users_Final:

LOAD quote_number,
           LastModifiedDate
FROM
Dimensiones\GPS_Quotes_Users2.qvd
(qvd);

Left Join

LOAD
   

     quote_number,
     customer_name,
     reference,
     abandon_reason,
     actual_close_date,
     yearClosed,
     monthClosed,
     dayClosed,
     actual_quote_submitted_date,
     month_actual_quote,
     year_actual_quote,
     day_actual_quote,
     gps_currency,
     yearDue,
     monthDue,
     dayDue

     .  

     .

     .

    n...FIELDS.....
  
FROM
Dimensiones\GPS_Quotes_Users.qvd
(qvd);
STORE GPS_Quotes_Users_Final INTO Dimensiones\GPS_Quotes_Users_Final.qvd;

drop Table GPS_Quotes_Users_Final;