Join on Condition

[#1]

I have dates and transactions comming from 2 SQL Tables

Calandar:

Date

9/1,

9/2,

9/3,

9/4,

9/5

Transx:

OrderDate, Order

9/1,1234

9/2,2345

9/4,5678

I want to join these tables and save into a QVD. And Transx Table should have all the dates(like 9/3, 9/5... )

I tried using Left join to using Where condition but its throwing an error. I cant name them same, because I'm getting Circularloop. (I'm using same Date table for other tables also)

Can anyone help me with solution?

[jonathandienst]

Hi

I don't know what you mean that you cant name them the same - you might need to supply more information about your model structure.

But that aside, this might work for you:

DataSet:
LOAD Date AS OrderDate 
From Calendar;
Join(DataSet)
LOAD OrderDate,
     Order
FROM Transx;

Hope that helps

Jonathan