SQL :
SELECT A.XH, A.MC, B.XH AS QDXH, B.AXH,B.BMC
FROM A, B
WHERE B.AXH = A.XH
--------------------------------------------------------------
INSERT INTO A
( XH , MC )
VALUES ( :XH , :MC )
INSERT INTO B
( XH , AXH , BMC )
VALUES (  DXH , :AXH , :BMC )
---------------------------------------------------
UPDATE A
SET XH = :XH ,
MC = :MC
WHERE ( XH = :OLD__XH )
UPDATE B
SET XH = DXH ,
AXH = :AXH,
BMC= :BMC
WHERE ( XH = :OLD__QDXH )
----------------------------------------------
DELETE FROM A
WHERE ( XH = :OLD__XH )
DELETE FROM B
WHERE ( XH = :OLD__QDXH ) |
楼主
发表于 2008-7-22 23:05:54
