quote:

---

Originally posted by kasaya

Hi...

this is my first post ^_^

INSERT INTO tbl (Name,Parameter, DataType,UserName,DataType)
VALUES ('name1.child',(SELECT Parameter,DataType FROM tbl2 WHERE Name = 'Chart1'),'admin','string')

can u help me fix this query ^_^

this query generates
Subqueries are not allowed in this context. Only scalar expressions are allowed.


this query will save hardcoded data and data result from the query

thanks,
KaSaYa

---

quote:

---

is this what you're trying to have?

INSERT INTO tbl
(Name,Parameter, DataType,UserName,DataType)
SELECT 'name1.child', Parameter, UserName, DataType
FROM tbl2
WHERE Name = 'Chart1'

Also I added the Username column on your selection because you might have been missed it, but if you want it not to be included on your insert then replace it with ''

Hope this helps.

---