[thelist] SQL: Insert with Sub Queries

[misterhaan]

Casey Crookston wrote:
> INSERT INTO photos (vehicleID, photo, isMain, sortOrder) VALUES
> ((SELECT vehicleID FROM Vehicles), (SELECT vehicleimage FROM  Vehicles),
> 'Yes', 1)
I would do it like this:
INSERT INTO photos (vehicleID, photo, isMain, sortOrder) SELECT 
vehicleID, vehicleimage, 'Yes', 1 FROM Vehicles