topic Re: Basic SQL question in QlikView

Basic SQL question

Thu, 23 Oct 2014 00:31:16 GMT

Hi guys, apologies first of all to ask stupid question

What i have is two tables

One is reference table with only one field in it which is color. Other is Oracle connection which has multiple fields in it and also field name "Base color".

What i am trying to do is to grab only fields which are equal to reference table "color" fields.

No issues with connecting to Oracle etc, but for some reason i cannot grab values which are equal. thanks in advance

Re: Basic SQL question

jagan — Thu, 23 Oct 2014 04:20:01 GMT

Hi,

Try like this

Reference:

SELECT

Color AS [Base color]

FROM ReferenceTable;

Other Table:

INNER KEEP(Reference)

SELECT

FROM OtherTableName;

Or use Exists(), refer Qlikview help file for reference and detailed help.

Hope this helps you.

Regards,

Jagan.

Re: Basic SQL question

anbu1984 — Thu, 23 Oct 2014 05:11:13 GMT

If both are Oracle tables, then try

Sql Select m.*

From Main_Tbl m Inner Join Ref_tbl r

on m.base_color = r.color