table alias nor valid for delete 
Author Message
 table alias nor valid for delete

Quote:

> I can't specify an alias for the table I want to delete from.
> Is this a bug or is that behavior mandated by the SQL standard?

No, and yes.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sun, 26 Sep 2004 04:54:25 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Table aliases in a Delete statement

2. Table aliases on a DELETE statement

3. instead of delete trigger delete data from table using execute and temporary table for deleted

4. Can't View DTS packages nor Tables using EM

5. Delete Alias in code

6. Modify or delete alias in code (D1)

7. Deleting or Changing an Alias

8. create a valid-to column from a valid-from column

9. ODBC Mngr deletes SQL Server Client aliases

10. BDE: Add/Delete Alias

11. How edit and delete alias in Delphi1?

12. deleting an alias from BDE at runtime


 
Powered by phpBB® Forum Software