Home > Blockchain >  SQL to find the match record based on the priority defined
SQL to find the match record based on the priority defined

Time:05-18

I have to build a logic to update one column SC_LEVI_LVL IN GCC_MAST.CLNT_MAST based on the match found on the below criteria:

(I am just looking at the select clause and I will update it later using update strategy in informatica)

The Joins needs to be made on three tables:

for Priority 1 the join needs to be made on below two tables:

GCC_LANDING.CB_AT_LIS CB
    GCC_MAST.CLNT_MAST TM

For Priority 2 the join needs to be made on below 3 tables:

GCC_LANDING.CB_AT_LIS CB
GCC_MAST.CLNT_MAST TM
GCC_LANDING.GRID_MATRIX GM

PRIORITY 1:

CB.REL_COUNTRY=TM.REL_COUNTRY
AND CB.GRID=TM.GRID
WHERE TM.SCH_LEG_ENTY NOT LIKE '           
  • Related