I need to insert records into a table where one value is fixed and 2 values come from a SELECT query, something like the following example:
INSERT INTO table1 fld1, fld2, fl3 VALUES value1, (SELECT fldx, fldy FROM table2) Is this valid? Respectfully, Jorge Maldonado