<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">I need to insert records into a table where
onevalue is fixed and 2 values come from a SELECT query, something like the following example:</span><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">INSERTINTO table1 fld1, fld2, fl3</div><div
style="font-family:arial,sans-serif;font-size:13px">VALUESvalue1, (SELECT fldx, fldy FROM table2)</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">Isthis valid?</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">Respectfully,</div><div
style="font-family:arial,sans-serif;font-size:13px">JorgeMaldonado</div></div>