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]
