Re: Insert using Subqueries
From: EijiTek (eijitek_at_comcast.net)
Date: 06/24/04
- Next message: mike: "Performance dramatically improved after reboot of server"
- Previous message: Lahoty: "Re: Insert using Subqueries"
- In reply to: Colin Basterfield: "Insert using Subqueries"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 17:45:04 -0500
Without knowing more about your schema (cardinality, structure, etc...), it
appears that this may be what you're looking for:
insert into site_revenue (site_id, revenue_id)
(select 2, r.revenue_id from revenue r where r.revenue_name='BAR/CAFE')
This will insert a row into site_revenue for each instance of revenue where
the name is 'BAR/CAFE'
"Colin Basterfield" <colin.basterfield@xtra.co.nz> wrote in message
news:T%uCc.3413$LT3.130652@news.xtra.co.nz...
> Hi,
>
> I want to do the following
>
> insert into site_revenue(site_id,revenue_id)
> values (
> 2,
> (select r.revenue_id from revenue r
> where r.revenue_name = 'BAR/CAFE'))
>
> Reason being I don't know what the revenue_id is when I call the routine
> that does the insert. I don't want to use a Stored Proc if I can help it.
>
> It complains however with this error
>
> >>Subqueries are not allowed in this context. Only scalar expressions are
> allowed.
>
> TIA
> Colin B
>
>
- Next message: mike: "Performance dramatically improved after reboot of server"
- Previous message: Lahoty: "Re: Insert using Subqueries"
- In reply to: Colin Basterfield: "Insert using Subqueries"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
