Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Since we're using INNER JOIN, only records that joined, would be deleted. According to Hugo's blog I gave you in the very top of this thread, it may be not ANSI standard to use JOIN in Update/DELETE commands.
>
>Alternative way to write the same delete would be
>
>delete from myTable where fName in (select fName from Dups)
>
>---------------------------------------------------------------------------------------------------------------------------
>BTW, last night I think I invented an interesting way to number records in one replace command, planned to even test it this morning, but forgot, of course.
>
>I may try it now then.
or or or u could tell me an ill test it for you :D
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement