Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>VFP 9 allowed the use of JOIN Syntax in SQL Deletes. Is there a limit to 1 JOIN?
No, there's not, so something else is going on. Is the query exactly what you're showing here or are you using outer joins?
Tamar
>When I created a DELETE SQL Command with multiple JOINS:
>
>DELETE tskdocs ;
> FROM tskdocs ;
> JOIN tasks ;
> ON Tskdocs.kd_t_id = Tasks.t_id ;
> JOIN taskdel ;
> ON Tasks.t_assgn_to = Taskdel.emp_no ;
>WHERE Taskdel.process AND Tasks.t_status = "I"
>
>The result was equivalent to:
>DELETE tskdocs ;
> FROM tskdocs ;
> JOIN tasks ;
> ON Tskdocs.kd_t_id = Tasks.t_id
>
>Even though the SQL Command:
>SELECT tskdocs.* ;
> FROM tskdocs ;
> JOIN tasks ;
> ON Tskdocs.kd_t_id = Tasks.t_id ;
> JOIN taskdel ;
> ON Tasks.t_assgn_to = Taskdel.emp_no ;
>WHERE Taskdel.process AND Tasks.t_status = "I"
>
>yields the correct result.
>
>Appears that only 1 JOIN is permitted in an SQL DELETE Command. Is this the case?
Précédent
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