Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- a.VALUE AS Varattuja_paikkoja,
- b.VALUE AS Paikkoja_yhteensä,
- (b.VALUE - a.VALUE) AS Vapaita_paikkoja
- FROM (SELECT COUNT(*) AS VALUE
- FROM Lentovaraus
- WHERE Lentopäivä='2011-10-20'
- AND LennonNumero='AY1115'
- ) AS a,
- (SELECT SUM(PaikkojenMäärä) AS VALUE
- FROM Penkkirivi
- WHERE KonetyypinNimi=(
- SELECT Konetyyppi
- FROM Lento
- WHERE Päivämäärä='2011-10-20'
- AND LennonNumero='AY1115'
- )
- ) AS b
Add Comment
Please, Sign In to add comment