You are correct Jim..
This is certainly not Cartesian.
"Jim Page - EMF Systems Ltd" <[EMAIL PROTECTED]>
04/07/2004 10:09 AM
Please respond to "Jim Page - EMF Systems Ltd"
To: "gerald_clark" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: stuck with simple query..... Plz have a look
Forgive me, but it would be a cartesian product if there were no where
condition, I agree? It would return (size Table1)x(size Table2)^3 rows,
definitely not what Tariq wants. The query I supplied will return (size
Table2)x(1)^3 rows won't it? Or am I missing the point?
Jim
> >SELECT ta.Name,tb.Name,tc.Name,Description
> >FROM Table2,Table1 ta,Table1 tb,Table1 tc
> >WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
>
> I t may work, but it may consume all ram and disk space in an attempt.
> It may take days.
> This is a 4 table cartesian product.
> There are no join criteria in the WHERE clause.
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
