Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT m.Model,m.Seats,v.Mileage FROM Models AS m
- INNER JOIN Vehicles AS v ON v.ModelId=m.Id
- LEFT JOIN Orders AS o ON v.Id=o.VehicleId
- WHERE ReturnDate IS NULL OR ReturnDate< GETDATE()
- ORDER BY v.Mileage,m.Seats DESC,m.Id ASC
Advertisement
Add Comment
Please, Sign In to add comment
