Hi,
FromBooks Online
Using Cross Joins
A cross join that does not have a WHERE clause produces the Cartesian product
of the tables involved in the join. The size of a Cartesian product result set
is the number of rows in the first table multiplied by the number of rows in
the second table.
eg 5 rows in A, 10 in B = 50 rows.
>>> [EMAIL PROTECTED] 10/07/2006 11:41 am >>>
Hi All,
I am trying to create a mapping table that will combine data from 2 tables.
Table A has the ID, Table B has another, and Table C will have all Table A
IDs and Tables B id's that match?
So Table C will look something like this
Table_C.A_ID | Table_C.B_ID
-------------------------------
100 | 300
100 | 301
121 | 330
122 | 331
I have this at the moment which isn't working
SELECT Bookings.BO_ID, BookingItems.BI_ID
INTO BookingOptions
FROM Bookings CROSS JOIN
BookingItems
Anyone see what it is I am doing wrong?
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
-~----------~----~----~----~------~----~------~--~---
