Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
i have a question please :
I got two tables with a common field "codeexpldef" . On the left table is called ADR_EXPL and on the right side adr_codif.
I'd like to have on a table the common numbers "Codeexpldef" of ADR_EXPL and adr_codif and all the informations of ADR_EXPL .
Should i do like that:
qualify*;
unqualify [Codeexpldef];
final:
load* resident ADR_EXPL2;
final:
Concatenate
load * resident adr_codif2 where exists (Codeexpldef);
i want all on a table but when i launched that, i have one table but with fields final... and final-1..
and if i did unqualify*; unstead qualify*; that not work no table created.
Thanks a lot and sorry for my bad english guys!
Hoping you want only one final table,
Load * from
ADR_EXPL ;
Left join
Load * from
adr_codif ;
Regards,
Prabhu
Method-1:
ADR_EXPL:
Load * From ADR_EXPL;
Inner Join
adr_codif:
Load * From adr_codif;
Method-2:
ADR_EXPL:
Load * From ADR_EXPL;
adr_codif:
Load * From adr_codif
where exists(ADR_EXPL.codeexpldef,adr_codif.codeexpldef);
Regards,
Pradeep