SELECT
users . *,
el.elo_name,
ed.ede_name,
ent.ent_name,
c1.chl_label AS country,
c2.chl_label AS state,
c3.chl_label AS city
FROM
( SELECT *,
CASE users.usr_active
WHEN "1" THEN "YES"
WHEN "0" THEN "No"
END AS users_active
FROM users
) as users
LEFT JOIN
choicelist c1 ON users.usr_country = c1.chl_value
AND c1.chl_element = 'country'
LEFT JOIN
choicelist c2 ON users.usr_state = c2.chl_value
AND c2.chl_element = 'state'
LEFT JOIN
choicelist c3 ON users.usr_city = c3.chl_value
AND c3.chl_element = 'city',
entity ent,
entity_locations el,
entity_departments ed
WHERE
users.usr_entity_location_id = el.id
and users.usr_entity_department_id = ed.id
告诉我我要去哪里错了
让我们开始吧...
SELECT
el.elo_name,
ed.ede_name,
ent.ent_name,
c1.chl_label AS country,
c2.chl_label AS state,
c3.chl_label AS city,
CASE u.usr_active
WHEN "1" THEN "YES"
WHEN "0" THEN "No"
END AS users_active
FROM users u
LEFT JOIN
choicelist c1 ON u.usr_country = c1.chl_value
AND c1.chl_element = 'country'
LEFT JOIN
choicelist c2 ON u.usr_state = c2.chl_value
AND c2.chl_element = 'state'
LEFT JOIN
choicelist c3 ON u.usr_city = c3.chl_value
AND c3.chl_element = 'city'
Join entity ent
On SOME CRITERION REQUIRED HERE
Join entity_locations el
On u.usr_entity_location_id = el.id
Join entity_departments ed
on u.usr_entity_department_id = ed.id
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句