Re: Left Join

[Jay Pipes]

Because MySQL is not MS Access.

No [ ] around the table name.
Get rid of all the Access-inserted parentheses.
Don't use keywords as table names.
Using DISTINCT with tableA.*, tableB.* is pointless. Specify column names.

Your query written properly:

SELECT DISTINCT m.*, d.*
FROM DepartmentWorkstations d
LEFT JOIN `month` m
ON d.chg_type = m.ChargeType
AND d.item_code = m.ItemCode
AND d.schedule = m.ScheduleCode
WHERE d.chg_type != 'p';

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com