SELECT * FROM `charges`
UNION ALL
SELECT * FROM `confinement`
UNION ALL
SELECT * FROM `ultrasound`
WHERE procedure_no IN (100, 200)
ORDER BY FIELD(procedure_no,100,200);
SELECT * FROM `charges`
UNION ALL
S SELECT * FROM `charges`
UNION ALL
SELECT * FROM `confinement`
UNION ALL
SELECT * FROM `ultrasound`
WHERE procedure_no IN (100, 200)
ORDER BY FIELD(procedure_no,100,200);
SELECT * FROM `charges`
UNION ALL
S