Re: Linking to a LUT more than once
Hi Shawn
Thanks for the incredibly rapid response! The query you provide almost does what I want except that the sire breed data is duplicated in BOTH the sire and the dam columns of the results table even though the breed code for dam in the original data table is different from the sire code. The results table I got is:
dog sire dam
1 poodle poodle
2 Terrier Terrier
3 labrador labrador
I'm not sure I understand your very first sentence, namely, "You are not tracking the dam code for the dog, so you can never display it. It's not in the join(s), it's in the data." Could you elaborate, please?
Thanks,
Phil
Subject
Written By
Posted
Re: Linking to a LUT more than once
August 05, 2011 08:43AM
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.