SHARE
TWEET

Untitled

psi_mmobile Jun 5th, 2020 759 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ax.str ,
  2.   b.str
  3. FROM
  4.   (SELECT v.person_id,
  5.     v.date_day,
  6.     v.str
  7.   FROM V_EXPORT_GROUPS_VALENS_2020_2 v ,
  8.     GU_PERSON GP
  9.   WHERE v.PERSON_ID =GP.PERSON_ID
  10.   AND GP.GUI_USER_ID= 101952
  11.   AND date_day     >= TO_DATE('01/05/2020', 'dd/MM/yyyy' )
  12.   ) ax,
  13.   (SELECT v.person_id,
  14.     v.date_day,
  15.     v.str
  16.   FROM V_EXPORT_GROUPS_VALENS_2020 v ,
  17.     GU_PERSON GP
  18.   WHERE v.PERSON_ID =GP.PERSON_ID
  19.   AND GP.GUI_USER_ID= 101952
  20.   AND date_day     >= TO_DATE('01/05/2020', 'dd/MM/yyyy' )
  21.   ) b
  22. WHERE ax.person_id = b.person_id (+)
  23. AND ax.date_day    = b.date_day;
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
Top