IBM Mainframe Forum

Hi ,
I have the following requirement in my team .Request you to help me on how this is possible using a join Query
Requirment:

I have two Table - say Table 1 and Table 2.
-------------------------------------------
Query for Table 1:
select distinct(ID) from Table 1
where (condn)
----------------------------------------------
Query for Table :
select distinct(ID) from Table 2
where (condn)
---------------------------------------------
My criteria is to delete and insert into Table 2 for the following scenario:
Table 1 Table 2 Action 1
----------------------------------------------
present present no action
not presen present delete from Table 2
present not present insert into Table 2
------------------------------------------------
Please advise me on how to proceed with the Changes using Joins.Is it possible to do so.If so can you please help as it an urgent requirement popped up in my team.Could you also provide the code procedure on how to proceed.Thank you.

Hello and welcome to the forum,

If so can you please help as it an urgent requirement popped up in my team.

You need to understand that we don't do urgent. . .

Why do you believe "distinct" should be considered?

Why do you believe this must be done with a single query?

Hi,

You can use Full Outer Join on the tables.

e.g.



then in your code you can check for the null indicators.
Code'd

@Dick -- I thought it would be feasible for me if we apply single query for insertion instead of multiple Query

@manasi - Thank you Manasi.I will try and let you on how is it going.

Thanks all

suppose col1 is primary key :