That immediately begs the question "How many cartesion joins does it take to match the US national debt?" At 01:05 PM 12/18/2009, Allen, Brandon wrote:
Ha ha! I'd suspect your developer might benefit from reading this link: <http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#sthref3170>http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#sthref3170I had to test it and found it's pretty easy to beat that with a few cartesian joins - I got a cost of 939 quadrillion:
Regards Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com