Advertisement
Guest User

Untitled

a guest
Jun 17th, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. SELECT CASE WHEN io.point IS NULL THEN oo.point ELSE io.point END
  2.      , CASE WHEN io.DATE IS NULL THEN oo.DATE ELSE io.DATE END
  3.      , io.inc
  4.      , oo.OUT
  5.   FROM Income_o io
  6.   FULL JOIN Outcome_o oo  
  7.     ON oo.point = io.point AND oo.DATE = io.DATE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement