MySQL Forums
Forum List  »  General

Re: Linking to a LUT more than once
Posted by: Philip Jones
Date: August 05, 2011 09:17AM

Apologies for the confusion - that's down to my incredibly clunky description of the problem.

When I have a table with just sire, there's no problem:

|---------------|--------------|
| unique_id | sire_code |
|---------------|--------------|
| 1 | 3 |
| 2 | 5 |
| 3 | 1 |
| 4 | NULL |
| 5 | 5 |
| etc | ... |
|---------------|--------------|


... but when I expand that table to include dam information (with both sire and dam codes referring to the same LUT), that's when I run into problems.


|---------------|--------------|--------------|
| unique_id | sire_code | dam_code |
|---------------|--------------|--------------|
| 1 | 3 | 2 |
| 2 | 5 | 3 |
| 3 | 1 | 4 |
| 4 | NULL | 5 |
| 5 | 5 | 5 |
| etc. | ... | ... |
|---------------|--------------|--------------|


Cheers,

Phil

Options: ReplyQuote


Subject
Written By
Posted
Re: Linking to a LUT more than once
August 05, 2011 09:17AM


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.