Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Namn, Kun.Förnamn, Summa, Lev.Förnamn, Lev.Efternamn, Provision.Provision, (Summa*Provision.Provision/100) AS Intjänat FROM Bud
- INNER JOIN Auktion ON Bud.Auktionsnummer = Auktion.Auktionsnummer
- INNER JOIN Leverantör ON Leverantör.Leverantörsnummer = Auktion.Leverantörsnummer
- INNER JOIN Provision ON Provision.ProvisionsID = Leverantör.ProvisionsID
- INNER JOIN Personkontakt AS Lev ON Lev.InformationsID = Leverantör.InformationsID
- INNER JOIN Kund ON Bud.KundID = Kund.KundID
- INNER JOIN Personkontakt AS Kun ON Kund.InformationsID = kun.InformationsID
- WHERE Slutdatum BETWEEN '2014-12-01' AND '2014-12-31'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement