topic Connect 2 big SQL request together in App Development

Connect 2 big SQL request together

Frédéricdh — Wed, 06 Mar 2024 10:42:37 GMT

Hello,

how to connect two big SQL Request together in Qlikview. I try to have two dimensio with the same Name but I doesn't work.

thanks for helping

Frédéric

Re: Connect 2 big SQL request together

JonnyPoole — Wed, 06 Mar 2024 15:37:04 GMT

You can JOIN (inner, outer, left, right) the tables together by aliasing the field(s) you want to join on the exact same way (case sensitive), or you can concatenate (stack) the tables together and again alias the field(s) that you want to be aligned be aliased the exact same way (case sensitive).