Hi Svein, Tks very much for your quick answer. Indeed, the statement did return one row. Instead of adding it to POSICOES, i removed it from EXCESSOS_VELOCIDADE. After this i was able to create the FK.
Again, thank you very much for your help. 2012/1/26 Svein Erling Tysvær <svein.erling.tysv...@kreftregisteret.no> > Does this statement return any rows? > > SELECT EV.POSICAO_ID_FINAL > FROM EXCESSOS_VELOCIDADE EV > WHERE NOT EXISTS(SELECT * FROM POSICOES P WHERE P.COMUNICACAO_ID = > EV.POSICAO_ID_FINAL) > > If so, that value must be added to POSICOES before you can create your > foreign key. > > HTH, > Set > [Non-text portions of this message have been removed]
