link between tables

[Anonymous]

I have the following script

QV 
Vente:
LOAD
 [Code Site]
      ,[Code Article]
,date
.....

from vente

How could I integrate the following query

SELECT [Code Site]
      ,[Code Article]
      ,[PrixVente]
      ,[Date debut]
      ,[Date fin ]
  FROM [dbo].[PrixVentePermanent]

How could I use intermatch and applymap to link between vente and prixventepermanent where vente.codesite=prixventepernent.codesite and [pPvente.codearticle=prixventepernent.codearticle

and vente.date between date debut and date fin ?

[Peter_Cammaert]

Like this?

INTERVALMATCH(date, [Code Site], [Code Article])

LOAD [Date debut], [Date fin], [Code Site], [Code Article];

SELECT ...

FROM ...;

This will create a synthetic key (no danger there). You can perform a LEFT JOIN twice to add PrixVente into table Vente.

Best,

Peter

[Anonymous]

see this, will be helpful for you:

IntervalMatch