Re: [SQL] left join syntax

2001-05-08 Thread Oliver Elphick
"Haywood J'Bleauxmie" wrote: >I have a database that tracks work orders. Each order tracks two entries >from the employees table; the employee ID of the person assigned to the >work order and the ID of the person who completed the order. Each work >order may have one, both, or neither f

[SQL] left join syntax

2001-05-08 Thread Haywood J'Bleauxmie
I have a database that tracks work orders. Each order tracks two entries from the employees table; the employee ID of the person assigned to the work order and the ID of the person who completed the order. Each work order may have one, both, or neither field filled in. As such, I need to left