Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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
Luminary Alumni
Luminary Alumni

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.