Question about a query

Databases
1

How can I adjust the query below to return results if stories.volunteer_id is null in a reccord?


SELECT stories.title, stories.id as 'id', stories.content as 'description', organization_name, partner_id, volunteer_id, concat(first_name, ' ', last_name ) as 'name', partners.city as 'city',partners.country as 'country'
				
FROM stories, partners, volunteers
				
WHERE stories.volunteer_id=volunteers.id 
				
AND stories.partner_id=partners.id
				
ORDER BY id DESC

Thanks E

2 
SELECT ...
  FROM stories
[COLOR="Blue"]INNER[/COLOR]
  JOIN partners
    ON partners.id = stories.partner_id
[COLOR="red"]LEFT OUTER
  JOIN[/COLOR] volunteers
    ON volunteers.id = stories.volunteer_id
3

Thanks so much. You are expanding my horizons. E