Join greater than

[#1]

Hi all,

I hope this is a smple question:

Is there a way to implement the following query in qlikview?

SELECT * FROM

TABLE_A A

INNER JOIN

TABLE_B B

ON

A.Field1 > B.Field2

AND

A.Field3 < B.Field4

Thanks in advance.

[alexandros17 · Accepted solution]

Unfortunately Not directly, you need at first to join the tables with both fields then reload the resulting table and use a where condition as you need.

[its_anandrjs]

Not with single table but you can use resident load for this and try with

tmpSource:

SELECT * FROM

TABLE_A A

INNER JOIN

SELECT * FROM

TABLE_B B

NewFinalTable:

Noconcatenate

Load * Resident tmpSource

Where

Field1 > Field2

AND

Field3 < Field4;

Drop Table tmpSource;

[alexandros17]

Inner join will let you lose records ... you need an (outer) join