About left join

[#1]

Hi All,

Can you help me out on the Left join?

In sql we can use those script:

Select c.CustomerName, o.Revenue

from Customers c

left join Orders o

on c.MemberId=o.MemberId and o.OrderDate >= c.CreateDate

In QV, the left join just works on the same field name, how can we achieve those condition: o.OrderDate >= c.CreateDate?

Thanks.

[Anonymous]

Rename the OrderDate -> CreateDate or vice versa before joining and it should work the same way

[#3]

Hi Johannes,

Thanks for your reply, I understand we can rename that 2 fields into one to achieve the linking, however, I was wondering whether we can use like "Greate than equal to" sign to filter the record by using the Left join in QV?

[#4]

Hi,

i dnt think it is possible to achieve this using join only, u need to take the Resident load and apply the filter there to achieve the date comparison.

As far as renaming the date field is concerned as suggested above, i dnt understand what u wud achieve with that in terms of joining,as the field to join is Memberid, why do we need to create a composite key of

Memebrid & date which wud give completely different result ?

Regards