well.. thank to szlamany, i saw that my last post was quite simple...
and my problem a bit more complicated..
i'll try to tell exactly what i need
i have a table called Foto, one called Noticia, Area and one called Unidade.
i need to make a copy of everything associated with idUnidade = 17
but in another idUnidade (30)..
so if i have one Row in Noticia with idNoticia = 30 and the idUnidade from that idArea is 17, than i need it to be copied AND the data from table Foto that have the idNoticia = 30, will be copied and idNoticia will be updated to the idNoticia of the new data...
i don't know it can be done only with SQL Server.. so, if don't, could someone suggest a program to help me!?
thanks in advance...
Last edited by Daskalos; Apr 11th, 2005 at 05:06 PM.
Reason: forgot the picture...
[vbcode]Dim Daskalos As NewBie
If My.english = Wrong Then
Forgive My.Poor.English
End If[/vbcode] Ða§kalø§
ICQ#: 36146307
Current ICQ status: More ways to contact me
Reply With Quote