You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
651 B
20 lines
651 B
SELECT * FROM Report WHERE EID=80392
|
|
SELECT * FROM Enrollment_FeeItem WHERE ID=1035912
|
|
|
|
UPDATE Enrollment_FeeItem SET ItemClass='检查' WHERE FeeItemName='液基薄层细胞制片术' AND ItemClass IS NULL
|
|
|
|
UPDATE Exam_Result SET DID=A.PID
|
|
-- SELECT A.*,B.EID
|
|
FROM Exam_Result A
|
|
LEFT JOIN Exam_Part B ON A.PID=B.ID
|
|
LEFT JOIN Enrollment_Patient C ON B.EID=C.ID
|
|
WHERE RptItemName LIKE '乙肝%' AND C.SignTime>'2024-06-16'
|
|
|
|
|
|
UPDATE Exam_Result SET DID=NULL
|
|
-- SELECT A.*,B.EID
|
|
FROM Exam_Result A
|
|
LEFT JOIN Exam_Part B ON A.PID=B.ID
|
|
LEFT JOIN Enrollment_Patient C ON B.EID=C.ID
|
|
WHERE RptItemName LIKE '乙肝%' AND C.SignTime>'2024-06-16'
|
|
|
|
|