[insert][select] Subqueries not allowed

Bonjour à tous,
Un petit probleme de query:

Code:

---

1 2	insert into tbl_user (login_name, password, user2company) values ('test','test', (select id from tbl_company where name='thisname'));

---

me renvoie

Code:

---

1 2	subqueries are not allowed in this context. Only scalar expressions are allowed.

---

Qu'un a une idée ?
Merci

Citation:

---

Envoyé par septentryon01

Code:

---

1 2	insert into tbl_user (login_name, password, user2company) values ('test','test', (select id from tbl_company where name='thisname'));

---

---

pour ton exemple essaye ceci :

Code:

---

1 2	insert into tbl_user (login_name, password, user2company) select 'test', 'test', id from tbl_company where name='thisname'

---

super merci beaucoup !!
septentryon