Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple JOINS Permitted using SQL DELETE?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Multiple JOINS Permitted using SQL DELETE?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Database:
Visual FoxPro
Divers
Thread ID:
01654971
Message ID:
01654971
Vues:
49
VFP 9 allowed the use of JOIN Syntax in SQL Deletes. Is there a limit to 1 JOIN?

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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform