Billing Address vs. Home Address

[stewm]

I have a scenario that exists where a report needs a customers billing address and their home address. This address can be different.

There are 3 tables involved...

Account Table - bill_address_key
Customer Table - address_key
Address Table - address_key

In my catalog I defined a join from the Account Table to the Address Table and my report does that join. By adding a join from Customer Table to Address the query that gets generated wants the bill_address_key and the address_key to both equal address_key. This is never happens that they will both equal address key.

How can I modify the report or catalog to go at the address table 2 different ways? Thanks.

Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada

http://www.consultantsclub.biz

 

[drlex]

Can't you alias the address table (call it home address) and join it to the customer table?

With the customer table joined to the Account table by customer number (or suchlike), you should always be able to get the customer home address from the aliased table and the billing address from the address table.

soi la, soi carré