Using Select query inside insert query

[Jose Mon]

Hi,

In an insert statement I want to insert some data from another table.
I used select query inside the insert query, but the database gives error.
I tried this in MySQL.

insert into t1(currency,price) values('USD',
select price from t2 where id='10'
)

Can anyone correct this query.

Thanks in advance..

[Srinivasa Raghavan]

In Oracle, I dont think you can use both value & a select statement in a insert query.
[ May 09, 2007: Message edited by: Srinivasa Raghavan ]

[Mark Spritzler]

Try something like this

[CODE]
INSERT INTO t1(currency,price)
SELECT 'USD',
price
FROM t2
WHERE id='10'
[\CODE]

Mark