Query is not working

[raj08536]

I have two tables. One is 2nd Level AFDA and other InterCompany

2nd Level AFDA has 5 fields and Intercompany has two.

Both have SAPStrNo field comman. I want to join thes tables and ignore all the SAPStrNo records found in InterCompany. Following SQL query is not working.
I have 1206 records in 2nd Level AFDA and 22 records in Intercompany. Following Query generate 26531 records which definetly wrong because I expect less than 1206 records due to this query


SELECT [2nd Level AFDA].SAPStrNo, [2nd Level AFDA].StoreNo, [2nd Level AFDA].AccType, [2nd Level AFDA].Sortype, [2nd Level AFDA].Banner
FROM [2nd Level AFDA] where [2nd Level AFDA].SAPStrNo <> InterCompany.SAPStrNo;

 

[Richard Schollar]

Hi

So you want all records in 2nd Level AFDA that has no match in Intercompany?

SELECT T1.SAPStrNo, T1.StoreNo, T1.AccType, T1.Sortype, T1.Banner
FROM [2nd Level AFDA] T1 LEFT JOIN Intercompany T2 On T1.SAPStrNo = T2.SAPStrNo WHERE T2.SAPStrNo Is Null;