[RESOLVED] INSERT with Multiple Queries

[jsc0624]

Hi Guys,

I don't know how to write this in proper SQL Commands:

INSERT INTO tblTable1
(
   Field1,
   Field2,
   Field3
)
VALUES
(
   @Field1,
   (SELECT FieldID FROM tblTable2 WHERE FieldName = @FieldName),
   (SELECT FieldID FROM tblTable3 WHERE FieldName = @FieldName)
)

That code doesn't work with my Stored Procedure.

Thanks in advance