DefconDotNet

Untitled

Apr 18th, 2013
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.21 KB | None | 0 0
  1.  
  2. Select Facturen.TotaalBedrag
  3.      , (Select Mutaties.Bedrag FROM Mutaties where Soort = 1) as TeBetalen
  4.      , (Select Mutaties.Bedrag FROM Mutaties where Soort = 2) as Betaald
  5. From Facturen
  6. where TeBetalen <> Betaald
Advertisement
Add Comment
Please, Sign In to add comment