Left Join Issue

[New-Qlik]

Hi.

I have two tables and doing left join

Items:

SQL SELECT
        CustID,
    OrderNo,
    OrderType,
    ReqNo,

ReqDate  
FROM Table1
where
ReqDate>= '2016/02/26' and ReqDate<= '2016/03/26';

left  join (Items)

SQL SELECT
        ProductMasterID,
    ProductName,
    ReqNo
FROM .Table2;

Table1  return 2lacs record and Table 2 retursn 4 lacs when we run this query in database

but in Qlikview

table 1 returns 2 lacs

where as table 2 is fetching more that 10  crores

so basically doing cross join.

Please guide what wrong I am doing.

TIA

[Clever_Anjos]

LOAD *;

SQL

SELECT
        CustID,
    OrderNo,
    OrderType,
    ReqNo,

ReqDate  ,

ProductMasterID,

    ProductName

FROM Table1

LEFT join Table2 on Table1.ReqNo = Table2.Reqno
where
ReqDate>= '2016/02/26' and ReqDate<= '2016/03/26';

[New-Qlik]

Thanks Clever but this is not working.

We cant write like this in Qv. Syntax error

[New-Qlik]

Just read that this was a bug in QV 12 SR1

But I am using QV12 only:(

Left join broken in QlikView 12 SR1?