Jim Page - EMF Systems Ltd wrote:
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;
Should work Jim
(This email has been scanned for viruses by www.emf-systems.com)
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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
