I am facing a case with inner join over two mssql tables name T1(main) and T2 (lookup). When T2 is having no data at all, the inner join reject works perfectly and goes to the reject output . But when T2 has some rows, say 40 and T1 is having 100 rows, all 100 rows are going in the main output and reject is being blank, instead of (40 main + 60 reject). So, it works as left outer join in case T2 has some data.
Has anyone faced the same issue and help me in resolving this?
Note: My main and reject output tables are same as the T2 table with different entries defined in the tmap.
I have attached tmap screenshot, is there any problem in that, considering inner join and rejects?
When Main table is having 800 rows, and lookup has 154 rows, how can inner join show 800 rows in main output? It is questioning the basic definition of inner join.
Running the same query in sql server gives the correct 154 rows for inner join.
Do you see such problem with inner join in community edition in general?
