Sure there could be problems if it's large. In my explanation (in a different message) I noted that it wasn't the most efficient query in the world, but he wanted one query to get that answer. Steve Meyers
> -----Original Message----- > From: Woolsey, Fred [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 25, 2001 9:58 AM > To: [EMAIL PROTECTED] > Subject: RE: Query help... > > > Quite a neat trick... but might there be problems with cross join > performance if the table is large? This is based on the assumption that > MySQL first creates the cross product, then culls out the rows that don't > meet the criteria. > > Cheers, > Fred Woolsey --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
