ÇóSQLÓï¾ä¡«

SQL code:

SELECT *
from [SEIZEHD].[dbo].[TDSC_CC_CASHIS00] A ,[SEIZEHD].[dbo].[TBL_TDSC_CC_CASHIS00] B
WHERE A.ATTRIB_03 = B.ATTRIB_03 AND A.ATTRIB_05 = B.ATTRIB_05 AND A.ROW_ID = B.ROW_ID



ÉÏÃæÓï¾ä¿ÉÒÔ²éѯ³öÀ´2¸öһģһÑùµÄ±íÖеÄÏàͬµÄÊý¾Ý¡£

ÎÒÏëɾ³ý [SEIZEHD].[dbo].[TDSC_CC_CASHIS00] Õâ¸ö±íÀïµÄÕâЩÊý¾Ý£¬ÇëÎÊÓï¾äÔõôдÄØ£¿

---

¾ßÌåµã.............

---

SQL code:
--try
delete a
from [SEIZEHD].[dbo].[TDSC_CC_CASHIS00] A ,[SEIZEHD].[dbo].[TBL_TDSC_CC_CASHIS00] B
WHERE A.ATTRIB_03 = B.ATTRIB_03 AND A.ATTRIB_05 = B.ATTRIB_05 AND A.ROW_ID = B.ROW_ID

---

Ö÷¼üÊÇʲô°¡

delete from [SEIZEHD].[dbo].[TDSC_CC_CASHIS00] where Ö÷¼ü in (SELECT Ö÷¼ü
from [SEIZEHD].[dbo].[TDSC_CC_CASHIS00] A ,[SEIZEHD].[dbo].[TBL_TDSC_CC_CASHIS00] B
WHERE A.ATTRIB_03 = B.ATTRIB_03 AND A.ATTRIB_05 = B.ATTRIB_05 AND A.ROW_ID = B.ROW_ID
)

---

---

1Â¥ Õý½â°¡

ÎÒÔõôûÏëµ½°¡¡£¡£555555555¡«
ллÄ㣻