Re: Insert using Subqueries

Next message: EijiTek: "Re: Insert using Subqueries"
Previous message: The Fat Controller: "Re: My girlfriend naked 3602"
In reply to: Colin Basterfield: "Insert using Subqueries"
Next in thread: EijiTek: "Re: Insert using Subqueries"
Messages sorted by: [ date ] [ thread ]

From: Lahoty (rajeev_lahoty_at_yahoo.com)
Date: 06/24/04

Date: 24 Jun 2004 11:58:26 -0700

Did you try

INSERT INTO site_revenue(site_id, revenue_id)
SELECT 2, r.revenue_id
FROM revenue r
WHERE r.revenue_name = 'BAR/CAFE'

HTH
-Rajeev Lahoty

Relevant Pages

Re: Help!! with a formula
... HTH ... (remove nothere from the email address if mailing direct) ... > column A with the revenue figure, what formula would I use to work out the ...
(microsoft.public.excel.worksheet.functions)
Re: how do I combine multiple IF statements to come up with 1 value?
... HTH:>) ... Windows XP & Office 2007 ... The formula I created now double counts the amount of revenue and that is ...
(microsoft.public.excel.worksheet.functions)