Saravanan Ponnusamy

Saravanan Ponnusamy

  • 349
  • 4.3k
  • 1.1m

MSSQL Query to MySQL Query

Aug 16 2019 10:28 PM
can anyone pls. convert the following MSSQL Query to MySQL Query...
 
 
SELECT tbl_use.fld_use_id AS UseID,
( SELECT CAST( endar.fld_endars_id AS VARCHAR(8000) ) + ISNULL(','+ STUFF(( SELECT ',' + CAST( fld_endars_id AS VARCHAR(8000) ) FROM tbl_endars
INNER JOIN tbl_endar_lca AS endar_LCA ON fld_endar_lca_endars_id = fld_endars_id
WHERE endar_LCA.fld_endar_lca_use_id = 1 AND endar_LCA.fld_endar_lca_privilege >= 4
FOR XML PATH( '' ) ), 1, 1, '' ),'') ) AS endarID,
tbl_use.fld_use_ail AS Useail
FROM tbl_endars as endar
LEFT JOIN tbl_use ON endar.fld_endars_owner_id = tbl_use.fld_use_id
WHERE (tbl_use.fld_use_isive='true' AND tbl_use.fld_use_event = 'true' AND tbl_use.fld_use_anch_id IN ( '15430235434543' )) ORDER BY tbl_use.fld_use_anch_id
 
its urgent.. 
 
thanks in advance .. 

Answers (3)