select from another table if rows do or do not exist

[dannix]

Hi,

I hope I can explain this right:

Here is my statement so far:

SELECT shift_log.note, shift_log.id, shift_log.timestamp, shift_log.monitor, shift_log.handover,
shift_log.start_time, shift_log.finish_time, shift_log.sunref, shift_log.hpref, shift_log.hsbcref,
CONCAT(users.fname, " ", users.lname) AS users_name, equipment.name AS equipment_name, equipment_id";
FROM shift_log, equipment, users, part_usage
WHERE equipment.id = shift_log.equipment_id  AND  shift_log.user = users.id AND part_usage.shift_log_id = shift_log.id
ORDER BY shift_log.timestamp DESC 
 

The last AND statement (AND part_usage.shift_log_id = shift_log.id) in the where clause is not always true, I want to get the info if its there, but allow the statement to run if there are no records, but im lost as to how to do so. As it is i only get results for those that have an entry in part_usage, but I still want the other rows that have no entry in part_usage. Is this possible?

[r035198x]

Use a LEFT OUTER JOIN for that.