SET TMS_SOFTWARE_SCHD_NEW_CFG = SOFTWARE_GROUP
FROM TFSTERMCFG t1
LEFT JOIN MATERMCFG t2
ON t1.ACQ_ID=t2.ACQ_ID AND t1.MERCHANT_ID= t2.MERCHANT_ID AND t1.TERMINAL_ID=t2.TERMINAL_ID
****LEFT JOIN Example :
create table tableA
(
COL1 VARCHAR(255) null,
COL2 VARCHAR(255) null,
COL3 VARCHAR (255) null
)
insert into tableA values ('1','11','111');
insert into tableA values ('2','22','222');
insert into tableA values ('3','33','333');
create table tableB
(
COL1 VARCHAR(255) null,
COL4 VARCHAR(255) null
)
insert into tableB values ('1','X');
insert into tableB values ('2','Y');
insert into tableB values ('2', null)
select * from tableA;
select * from tableB;
1. Result for
select * from tableA a
left join tableB b
on A.col1=b.col1
COL1 | COL2 | COL3 | COL1 | COL4 |
1 | 11 | 111 | 1 | X |
2 | 22 | 222 | 2 | Y |
2 | 22 | 222 | 2 | NULL |
3 | 33 | 333 | NULL | NULL |
2.Result for
select * from tableA a
left join tableB b
on A.col1=b.col1
where b.col1 is null
COL1 | COL2 | COL3 | COL1 | COL4 |
3 | 33 | 333 | NULL | NULL |