Basic SQL question

[#1]

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

[jagan]

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.

[anbu1984]

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