Join IF

[Anonymous]

Hi All

Just wondering is there a way i can join data based on condition?

For Example i have Sales Table and Account info

I need

Load * From Sales

Left Join

Load * From Account

If accountdate > salesdate

I tried this and it does not work any ideas how to do this?

Thanks

[vinieme12]

No you can't do that but you can do the below

After joining only keep records that match your criteria

Temp:

Load * From Sales

Left Join

Load * From Account

;

Noconcatenate

Fact:

Load *

Resident Temp

Where accountdate > salesdate;

Drop table Temp;