Inner join in SQL Editor

Question

Hi Folks,

I am trying to extract data using custom SQL Query. I am trying to inner join two tables. While the query itself is not throwing any error, the number of records I am fetching using SQL Query is way greater than when I am trying to do the same operation using Alteryx Join tool. I am taking the output from the Inner join in the Join Tool.

Can anyone help me in understanding why this query is not giving the expected result. The output should have only 45 records but using query in SQL Editor I am getting some 145 Records.

select T.ItemType,
B.Item,
from T
inner join B on T.PROJEKT_Counter = B.Zaehler

atcodedog05 · Answer

Hi @Anshita

Not null should work can you show me the query. There is a possibility that it can also be a blank and not null.

Anshita · Answer

Hi @atcodedog05,

Thanks but really trying to combine all operations in a single query from the input tool directly! for now NOT NULL seems to be not working for me.

atcodedog05 · Answer

Hi @Anshita

You can use filter before joining to remove nulls