Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT runway_sign as Landebahn, [Anzahl gelandet], [Anzahl gestartet] from
- (
- SELECT runway_sign, COUNT(runway_sign) as [Anzahl gelandet], 0 as [Anzahl gestartet] FROM tbl_arriving_planes
- GROUP BY runway_sign
- ) as b
- UNION
- SELECT runway_sign as Landebahn, [Anzahl gelandet] ,[Anzahl gestartet] from
- (
- SELECT runway_sign, 0 as [Anzahl gelandet], COUNT(runway_sign) as [Anzahl gestartet] FROM tbl_leaving_planes
- GROUP BY runway_sign
- ) as a
- runway_sign | number of arrived planes | number of leaving planes
- SELECT runway_sign as Landebahn,
- SUM([Anzahl gelandet]),
- SUM([Anzahl gestartet])
- FROM ((SELECT runway_sign, COUNT(runway_sign) as [Anzahl gelandet], 0 as [Anzahl gestartet]
- FROM tbl_arriving_planes
- GROUP BY runway_sign
- ) UNION ALL
- (SELECT runway_sign as Landebahn, 0 as [Anzahl gelandet], COUNT(runway_sign) as [Anzahl gestartet]
- FROM tbl_leaving_planes
- GROUP BY runway_sign
- )
- ) al
- GROUP BY runway_sign;
- SELECT COALESCE(a.runway_sign, l.runway_sign) as Landebahn,
- a.[Anzahl gelandet],
- l.[Anzahl gestartet]
- FROM (SELECT runway_sign, COUNT(runway_sign) as [Anzahl gelandet]
- FROM tbl_arriving_planes
- GROUP BY runway_sign
- ) a FULL JOIN
- (SELECT runway_sign as Landebahn, COUNT(runway_sign) as [Anzahl gestartet]
- FROM tbl_leaving_planes
- GROUP BY runway_sign
- ) l
- ON l.runway_sign = a.runway_sign
- SELECT runway_sign as Landebahn, SUM([Anzahl gelandet]) as [Anzahl gelandet], SUM([Anzahl gestartet]) as [Anzahl gestartet]
- FROM (
- SELECT runway_sign, 1 as [Anzahl gelandet], 0 as [Anzahl gestartet] FROM tbl_arriving_planes
- UNION
- SELECT runway_sign, 0 as [Anzahl gelandet], 1 as [Anzahl gestartet] FROM tbl_leaving_planes
- ) as a
- GROUP BY runway_sign
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement