Help with SQL Inner Join Syntax in Qlikview

[#1]

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";

[maxgro]

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";

[#3]

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]

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.