Load and sql select

Wed, 21 Nov 2012 10:14:19 GMT

Good morning!
I would like a little help to mount a qvd.
I have the following sql code, composed of temporary tables that result in a third select with these results.

create table tb_tmp as (
select
cod
,ocorrencia
,dat
from tabA
)

;

create table tb_tmp2 as (
select
cod
,ocorrencia
,dat
from tabB
)

;

select
cod
,ocorrencia
,dat
from
(
select distinct
t.cod
,t.ocorrencia
,t.dat
from
(
select * from tb_tmp
) t
,
(
select * from tb_tmp2
) t1
where t.cod <> t1.cod
)

I need to create these qvds selects, but I doubt in the formation of the third sql, how to work within a Load sql select command?
Anyone have any tips for this situation?

tb_tmp:
sql
select
cod
,ocorrencia
,dat
from tabA;
store tb_tmp into tb_tmp.qvd;
drop table tb_tmp;

tb_tmp2:
sql
select
cod
,ocorrencia
,dat
from tabB;
store tb_tmp2 into tb_tmp2.qvd;
drop table tb_tmp2;

tb_3:
sql
select
cod
,ocorrencia
,dat
from
(
select distinct
t.cod
,t.ocorrencia
,t.dat
from
(
Load * from tb_tmp.qvd
) t
,
(
Load * from tb_tmp2.qvd
) t1
where t.cod <> t1.cod
);
store tb_3 into tb_3.qvd;
drop table tb_3;

Thank's

Re: Load and sql select

Gysbert_Wassenaar — Wed, 21 Nov 2012 11:22:01 GMT

Maybe I'm misunderstanding what you're trying to do, but if you want only the records from TabA that have no matching records in TabB, try this:

T1:

select distinct

cod as T1cod

from tabB;

Result:

load * where not exists(T1cod,cod);

select

cod

,ocorrencia

,dat

from tabA;

drop table T1;

Re: Load and sql select

Fri, 23 Nov 2012 09:01:44 GMT

thanks for your help

topic Re: Load and sql select in QlikView

Load and sql select

Re: Load and sql select

Re: Load and sql select