Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
thanks for your help