Advertisement
psi_mmobile

Untitled

Jun 5th, 2020
1,310
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.58 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement