Posted by pltaylor3 on 07/06/06 15:34

I have tried this insert comand and it errors out telling me that i
cannot use subqueries this way. INSERT INTO tblPartLocation
(PartLocation, Part)VALUES (999,(SELECT PartID FROM tblParts WHERE
PartName = 'test'))

how would i insert a value from a query?

thanks for any help

• Next in forum: Re: Insert Subqueries
• Prev in forum: Odd SQL IN usage?
• Thread view: Insert Subqueries

[Reply to this message]