MySQL Forums
Forum List  »  Oracle

Oracle SQL query not working in MySQL
Posted by: Jimmy James
Date: September 17, 2007 10:40AM

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'

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle SQL query not working in MySQL
3880
September 17, 2007 10:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.