I have 3 tables to join when the last one is a Full-Text table (ft_table).. I do the next join:
SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN ft_table USING (id) WHERE ... But MySQL selects the primary key (id) to join the ft_table, which makes the query run a lot of time and gives wrong results according to the MATCH AGAINST search.. I found that making the join as this: SELECT id,title FROM table1,table2,ft_table WHERE table1.id=table2.id AND table2.id=ft_table.id AND ... gives the wanted results according to MATCH AGAINST, but leave out rows that don't exist in table2 (the join there was LEFT JOIN).. 1- Is there a way to join the full-text table and using the full-text index, so the query will not last long? 2- Is there a way to make something like LEFT JOIN using list of tables seperated by comma (table1,table2,..)? 3- Is there a performance difference between making INNER JOIN or by making list of tables seperated by comma (table1,table2,..) with using WHERE clause? thanks a lot in advance, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
