a guest Jul 22nd, 2019 44 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select a.id_application
  2.       from  (SELECT * FROM t_mission as PM
  3.          LEFT JOIN t_mission_raf rm on PM.id_mission= rm.id_rm
  4.         LEFT JOIN t_mission_roles AS mr ON PM.id_mission = mr.id_mission
  5.         LEFT JOIN t_role AS r ON r.id_role = mr.id_role
  6.         LEFT JOIN t_appli AS app ON app.id_application = r.id_application
  7.          WHERE PM.type_mission = 1 AND PM.id_mission =24730) as a
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand