Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Joins in Designer using fields not part of join tables

Hi,

I have 3 tables:

Sales with fields {Sales_Key,Date_Key,ValidData_Key, TotalSales}

Date with fields {Date_Key, CalendarDate}

ValidData with fields {ValidData_Key,ValidEffDate, ValidEndDate}

I'm trying to create the following join in Designer between the three tables without creating a loop.

SELECT * FROM

Sales S,

Date D,

ValidData V

WHERE

S.Date_Key = D.Date_Key and

S.ValidData_Key = V.ValidData_Key and

D.CalendarDate between V.ValidEffDate and V.ValidEndDate

Essentially, I want to be able to use fields from table(s) other than the two tables involve in the join within the join condition. How can this be achieve?

Thanks,

Jimmy

Former Member
Former Member replied

Hi,

have you considered using a derived table for this?

Regards,

Stratos

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question