mardi 24 mars 2015

sql syntax error

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