If one of the tables contains records that are orphaned—for which there is no corresponding record with a matching value in the other table—those records are ignored.