Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. SELECT runway_sign as Landebahn, [Anzahl gelandet], [Anzahl gestartet] from
  2. (
  3. SELECT runway_sign, COUNT(runway_sign) as [Anzahl gelandet], 0 as [Anzahl gestartet] FROM tbl_arriving_planes
  4. GROUP BY runway_sign
  5. ) as b
  6. UNION
  7. SELECT runway_sign as Landebahn, [Anzahl gelandet] ,[Anzahl gestartet] from
  8. (
  9. SELECT runway_sign, 0 as [Anzahl gelandet], COUNT(runway_sign) as [Anzahl gestartet] FROM tbl_leaving_planes
  10. GROUP BY runway_sign
  11. ) as a
  12.  
  13. runway_sign | number of arrived planes | number of leaving planes
  14.  
  15. SELECT runway_sign as Landebahn,
  16. SUM([Anzahl gelandet]),
  17. SUM([Anzahl gestartet])
  18. FROM ((SELECT runway_sign, COUNT(runway_sign) as [Anzahl gelandet], 0 as [Anzahl gestartet]
  19. FROM tbl_arriving_planes
  20. GROUP BY runway_sign
  21. ) UNION ALL
  22. (SELECT runway_sign as Landebahn, 0 as [Anzahl gelandet], COUNT(runway_sign) as [Anzahl gestartet]
  23. FROM tbl_leaving_planes
  24. GROUP BY runway_sign
  25. )
  26. ) al
  27. GROUP BY runway_sign;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement