Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE GeefLeveranciers2
- @Plantennaam varchar(20)
- AS
- SELECT L.Lev_naam, P.Plantennaam, O.Off_prijs
- FROM Offertes O, Planten P, Leveranciers L
- WHERE L.Lev_code = O.Lev_code
- AND O.Art_code= P.art_code
- AND P.plantennaam = @Plantennaam;
- --uitvoeren
- EXEC GeefLeveranciers2 'berk'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement