Connect In-DB tool

[amnac]

I'm trying to run this subquery in alteryx design using Connect In-DB and Browse In-DB tool as follow: 

my query is like that

I have used visual query builder to develop this subquery. Now the problem is when I run it, it takes 40 minutes to run and nothing shows up on the browser result window

I need guidance with this problem and how to optimize this workflow

[amnac]

thank you all, I have somehow managed to get desired output by not using DB Join in my query. like this:

[apathetichell]

stupid question. is one of your DBs (the upper most) housed on a different server than the others? Or did you change a field type in the Join? Basically the way you solved your issue is downloading all of your data. Glad it worked - but not really sustainable...

[amnac]

No question is stupid :)
All DBs are same server from what I know. I tried with DB tool with same setting DB Joins it gives blank output.

[amnac]

I have the following workflow and it takes 8-10 hours to run, is there any way I can make it fast

I jave to use data stream out because all the processing tools I need are not in DB-Tools

[apathetichell]

Do as much processing as possible In-DB. You can use summarize in-db in group-by mode as a unique tool. You should not be using a Join on canvas if both tables are in the same DB.

[amnac]

how do we use summarize in-db as a unique tool?