When you specify a left join, you will always get the same number of records as are in your primary join table (barring other filters). So a left join assures that I get all the events, but leaves out the related contacts and regards if there is more than one.
I'm thinking I'm going to have use UNION to merge a few select statements.
On Mar 16, 2004, at 5:21 AM, Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>, Brent Baisley <[EMAIL PROTECTED]> writes:
You're right, it doesn't "fail", it just fails to give me the desired results.
Left joining won't work because it will only grab one record from contacts and/or regarding if one exists, when there could be many.
But that's not due to the LEFT JOIN, but due to the SELECT DISTINCT EventID.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
