From: Martijn Tonies (m.toniesupscene.com)
Date: Sun Apr 05 2009 - 12:50:35 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

>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
physical property.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]