have looked through the forums already but have been unable to solve this problem: Commands out of sync; you can't run this command now SQL
My query is:
SELECT Car.*, Building.*, CarType.*
FROM Car
INNER JOIN Building
ON Car.BuildingID=Building.BuildingID
INNER JOIN CarType
ON Car.CarType=CarType.TypeID
WHERE Car.CarID <> (SELECT CarID FROM Requests WHERE Status = 'Accepted')
Any help appreciated. thank you
See Question&Answers more detail:os