What would be the correct way to build this query: INSERT INTO photos (vehicleID, photo, isMain, sortOrder) VALUES ((SELECT vehicleID FROM Vehicles), (SELECT vehicleimage FROM Vehicles), 'Yes', 1) Thanks, Casey