how to retrieve column name in mysql query

Viewed 31
SELECT ud.id as userId,ud.organization_id,ud.first_name,ud.last_name,ud.image_url,ud.userOrg.name
     
     FROM
    (
        SELECT * FROM jhi_user ju 
        INNER JOIN 
        (
            SELECT manager,user_id,organization_id  FROM employee e 
            WHERE role_id in 
                        (SELECT id FROM role WHERE organization_id in 
                           (SELECT id FROM organization o WHERE sales_person_id = 3) 
                         and name = 'NEXCAR_SALES_PERSON' or name = 'NEXCAR_ADMIN' AND (deleted = 0 or deleted is null))
        ) userOrg ON ju.id = userOrg.user_Id
    ) ud
  
  
0 Answers
Related