I wouldn't do it like that Andrew
I would be using a VIEW, unless this is a temp thing your doing to cleanup
some data
if you went
CREATE VIEW Combined AS (
SELECT Bookings.BO_ID, BookingItems.BI_ID
FROM Bookings, BookingItems
WHERE Bookings.BO_ID = BookingItems.BI_ID
)
Then use the "Combined" VIEW as a table
Otherwise if your just looking at inserting the data into a table you can do
the same thing anyway
INSERT INTO BookingOptions (BO_ID, BI_ID)
SELECT Bookings.BO_ID, BookingItems.BI_ID
FROM Bookings, BookingItems
WHERE Bookings.BO_ID = BookingItems.BI_ID
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of Andrew Scott
Sent: Monday, July 10, 2006 11:50 AM
To: [email protected]
Subject: [cfaussie] Re: Help with a SQL Query
Steve,
SQL Server 2000
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
