Re: Table design issue and complex query questions
Posted by: David Usherwood
Date: August 19, 2012 12:00PM

Many thanks for the reply.

"The cd table possesses a compound key that hold the date i.e 365 record for each centre.
The cf table doesn't possess a daily date only a centre (CNA_ID) and startDatetime colum.
Hence I can't get a good join"

I mean that the cd table index is the centre id CNA_ID and dateReference so there are 365 recs for each distinct centre in the whole table. The startDateTime in the cf table is set to the 1/4/2012 (the start of our company year). So any joins between these two table can join against the CNA (this column is common) to both table but the cd.dateReference cannot be joined to the cf.startDateTime.

So instead of joining the to the cd table to the cf table I thought about joining it to the p table and added/introduced the effective date from/to - along with the left outer join.

Many thanks

Dave

Options: ReplyQuote


Subject
Written By
Posted
Re: Table design issue and complex query questions
August 19, 2012 12:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.