Join Tables! HELP

[farolito20]

I need to join both tables:

Table1:

codCosecha,

Start,

End,

Group1

Table2:

Date,

Group2

The condition to join:   (Group1=Group2) and (Date between Start and End)

Table3:

Date,

Group2,

codCosecha

Help!

[#2]

Hi,

QV uses natural joins: attributes with same name are joined, others not:

NullAsValue Start, End, Date;

load

Date,

Group2 as Group

resident Table2

inner join intervalmatch(Date, Group)

load

Start,

End,

Group1 as Group,

codCosecha,

resident Table1;

Greets

Klaus