Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Martijn Tonies (m.toniesupscene.com)
Date: Sun Apr 05 2009 - 12:50:35 CDT
>I have 3 tables that are 1:1 and will always have a row for a given
>product,_code & date. If I want to join them together, is it going to be
>faster to use an equi join or a left join, or does it matter?
Who cares, they are -different- things symantically, use the correct type of
join for your data and resultset. "Speed" is an implementation issue, a
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql