Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 10, 2009 at 08:38 AM

    Hi,

    have you considered using a derived table for this?

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded