我可以在INSERT语句中使用子查询吗？

I need to insert a row into a table, with one field value being calculated from another table. Rather than doing two queries and risking a race condition, I thought it'd be better to do it all in one statement.I need to insert a row into a table, with one f