How to use where condition when using join

[#1]

Hi All,

There are two tables call “item ” and “Working Hours ”. I want to join these table using QlikView.

I want to calculate the number of hours with in the dates ofMax_date and Min_date.

In sql I think write a join statement like this.

tables are

Item :      factory, Max_date,Min_date, Team

WorkingHoures:    date, factory, hours, Team

Select   item.* ,sum(hours)

From     item I

Inner join   Working Hours WH

On  I.factory =  WH. factory     and        I.Team = WH.Team

Where    I.Max_date   > =   WH.date  >= I.Min_date

How I solve this kind of problem in QlikView.

Thanks , Im waiting your answers .

[jagan]

Hi,

You can straightaway use this query to load into Qlikview.

TableName:

SQL Select   item.* ,sum(hours)

From     item I

Inner join   Working Hours WH

On  I.factory =  WH. factory     and        I.Team = WH.Team

Where    I.Max_date   > =   WH.date  >= I.Min_date;

Hope it helps you.

Regards,

Jagan.

[#3]

thanks Jagan.

Those data store in excel sheets. So first we have to loadthose data nw. can you give me help if don’t mind. This are the excel sheets .

thanks

Savi