Check if field value for a record exist
I have a couple tables that are related, each have a animal_ID field (these fields are seperate from the table unique auto serial ID)
In one table its imported data parsed from a xml file and what i need to do is have a field of some sort next to the animal ID where it says either - not found (the animal ID in this record for this table doesnt exist in the animal_ID field in the other table) or says nothing if there is a match.
Can someone tell me the best practices to achieve these results?
Thanks so much! :)