skip to Main Content

Mysql – sql query shows error by changing alias name

mysql> SELECT 'STATUS', status FROM (SELECT ujm.user_id AS userId, ujm.job_id AS jobId, ujm.job_run_name AS jobRunName, j.response_payload -> '$.isSuccessful' AS isSuccessful, j.response_payload -> '$.error' AS errors, j.response_payload -> '$.destinationDetails' AS destinationDetails, s.name AS statusType FROM user_job_mappings ujm JOIN jobs j ON…

VIEW QUESTION
Back To Top
Search