Oracle SQL query not working in MySQL

[Jimmy James]

Can anyone tell me why this will not work in MySQL. It works fine in Oracle.

SELECT a.fldMID AS "Id",
COALESCE(a.fldVALUE, 'none') AS "Disposition",
COALESCE(b.fldVALUE, 'none') AS "PTC Call Number",
COALESCE(c.fldVALUE, 'none') AS "Deployment",
COALESCE(d.fldVALUE, 'none') AS "Business Unit",
a.fldDATE as "Date"
FROM
(SELECT *
FROM tbl_form_values
WHERE fldFID = 1
)a,
(SELECT *
FROM tbl_form_values
WHERE fldFID = 2
)b,
(SELECT *
FROM tbl_form_values
WHERE fldFID = 3
)c,
(SELECT *
FROM tbl_form_values
WHERE fldFID = 4
)d
WHERE a.fldMID = b.fldMID
AND a.fldMID = c.fldMID
AND a.fldMID = d.fldMID
AND a.fldVALUE = 'General'
AND b.fldVALUE is null
AND c.fldVALUE = 'LDAP'
AND d.fldVALUE = 'NHD'