hi i have this query every time i run it it says syntax error near from, could anyone help me. I basically want to check is the vehicle associated with the booking has warranty if it does set total to 0.
"UPDATE Bookings SET total=0
FROM Bookings JOIN Vehicles on Bookings.CustomerID=Vehicles.CustomerID
WHERE hasWarranty='yes'";
Aucun commentaire:
Enregistrer un commentaire