Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple JOINS Permitted using SQL DELETE?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Multiple JOINS Permitted using SQL DELETE?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01654971
Message ID:
01654971
Views:
50
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?
Next
Reply
Map
View

Click here to load this message in the networking platform