Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with SQL Inner Join Syntax in Qlikview


I have 2 tables that I'd like to join reight from the SQL Select and not from QVD's. Can someone help me with the SQL syntax i would need within QV? I am trying to inner join on "device_form_sk". Thanks

SQL SELECT

     "device_sk",
     "device_form_sk"

FROM "mob_dw"."device_dim";

SQL SELECT "device_form_sk",
   "device_form_cd",
    "device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

3 Replies
maxgro
MVP
MVP

maybe

SQL SELECT

    a. "device_sk",
     a."device_form_sk",

     b."device_form_cd",

    b."device_form_desc" as "Device Form"

FROM "mob_dw"."device_dim" a,
"mob_dw"."device_form_dim" b

where a."device_form_sk"= b."device_form_sk";

    

Not applicable
Author

Hi,

try using preceding load:

Table1:

Load

     device_sk,

     device_from_sk;

SQL SELECT

     "device_sk",
     "device_form_sk"
FROM "mob_dw"."device_dim";

inner join(Table1)

Table2:

Load

     device_from_sk, // your link key

     device_from_cd,

     [Device From];

SQL SELECT "device_form_sk",
   "device_form_cd",
    "device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

Best regards.

jagan
Partner - Champion III
Partner - Champion III

Hi John,

Try like this

Table1:

SQL SELECT

     "device_sk",
     "device_form_sk"
FROM "mob_dw"."device_dim";

inner join(Table1)

SQL SELECT "device_form_sk",
   "device_form_cd",
    "device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

Hope this helps you.

Regards,

Jagan.