>> I would do it like this: INSERT INTO photos (vehicleID, photo, isMain, sortOrder) SELECT vehicleID, vehicleimage, 'Yes', 1 FROM Vehicles<< Perfect! Thanks