TheBugSlayer
Programmer
All,
A third-party vendor has submitted a script for execution to resolve an issue users are experiencing. Since this is serious business and the query is not in standard format, I want to make sure I understand its purpose correctly. The query is:
Code:
delete GL20000 from GL00100, GL20000 where GL20000.ACTINDX = 1234 and GL00100.ACCTTYPE = 9 and GL20000.SOURCDOC = 'XYZ'
When I substitute DELETE with SELECT, the query returns 5049 rows...That's a lot of rows to delete by accident!
Since there is no equation between both tables in the WHERE clause, I am not sure what's happening here. Can someone help me explain the query or write it in SQL-92 format?
Thank you!
MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA), Training HOTT cert SQL Server 2012 Business Intelligence (SSIS, SSAS).