select d.Id,c.last, c.first, c.parish, d.assigned as date, d.client, d.special, d.comment as delComment, v.first as vFirst, v.last as vLast from delivery d, client c, volunteer v where d.Id=521 and c.Id=d.client and d.volunteer=v.Id union select d.Id,c.last, c.first, c.parish, d.date, d.client, d.special, d.comment as delComment, '' as vFirst, '' as vLast from delivery d, client c where d.Id=521 and c.Id=d.client
select d.Id,c.last, c.first, c.parish, d.assigned as date, d.client, d.special, d.comment as delComment, v.first as vFirst, v.last as vLast from delivery d, client c, volunteer v where d.Id=523 and c.Id=d.client and d.volunteer=v.Id union select d.Id,c.last, c.first, c.parish, d.date, d.client, d.special, d.comment as delComment, '' as vFirst, '' as vLast from delivery d, client c where d.Id=523 and c.Id=d.client
St. Francis Fool Pantry - Welcome
** Welcome PAUL MARLIN. Select Option on Left
2 Deliveries closed out
8 clients, 2 deliveries, and 2 pickups deleted **