請檢查以下 MySQL 代碼。
SELECT seller_job_invites.idseller_job_invites,
seller_job_invites.idjob,
seller_job_invites.iduser as seller_id,
seller_job_invites.idjob_status,
user.iduser AS buyer_id,
user.first_name AS buyer_first_name,
user.last_name as buyer_last_name,
user.profile_picture AS buyer_profile_picture,
job.idjob_subcategories,
job.posted_date,
job.start_date,
job.location_lat,
job.location_long,
(SELECT IFNULL((SELECT translations.word FROM translations WHERE translations.dtype="JOB_SUB_CATEGORY" AND translations.language_code="FR" AND translations.fkey=job.idjob_subcategories) AS subcategory_name,(SELECT translations.word FROM translations WHERE translations.dtype="JOB_SUB_CATEGORY" AND translations.language_code="EN" AND translations.fkey=job.idjob_subcategories) AS subcategory_name)),
job_status.name AS 'job_status'
FROM peresia.seller_job_invites
INNER JOIN job ON seller_job_invites.idjob = job.idjob
INNER JOIN user ON job.iduser = user.iduser
INNER JOIN job_status ON seller_job_invites.idjob_status = job_status.idjob_status
WHERE seller_job_invites.iduser=52 AND (job_status.name = 'SELLER_SCREENING' OR job_status.name ='SELLER_INVITED')
請注意我正在使用的子查詢。我想要做的是回傳該單詞的法語翻譯，如果它為 NULL，則回傳英語單詞。
這給了我以下錯誤。
Error Code: 1583. Incorrect parameters in the call to native function 'ifnull'
我該如何解決這個問題？
uj5u.com熱心網友回復：
您似乎在 IFNULL 呼叫中分配別名。洗掉它們并在函式呼叫之外添加一個別名。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/365710.html