Insert with Select and Parameters

[hellaway]

first of all... Before someone comes here and tag it as "duplicated question" please take a better look to my question !I have an Insert that I was using \[code\]Parameters\[/code\] to pass the values but \[code\]only\[/code\] one field I need to take it's value with a select, look:\[code\]INSERT INTO chamados (club, project, function, description, priority) (@club, @proj, @func, @description, @pri)";\[/code\]Only the \[code\]club\[/code\] field I need to get from a SELECT query. How Do I do that?Obs: It's not a duplicate question. All I saw in the others threads, it was showing how to get \[code\]all\[/code\] the values from a select, while I just need one... All the others values i'm passing by parameters/strings . . .