Is it possible to circumvent this and force the other tables display their content?

Here’s my novice inquiry regarding this query:

SELECT * FROM itinerary, pastor, church, service, expense
WHERE itinerary.itinerary_id = pastor.itinerary_id
AND pastor.pastor_id = church.pastor_id
AND church.church_id = service.church_id
AND service.service_id = expense.service_id

My question is:

Can all records be shown from several tables although one table has no match on (service.service_id = expense.service_id) in the above query?

Currently the query fails, and none of the tables that have content show at all if the last table (expense) has no id match (service.service_id = expense.service_id).

Is it possible to circumvent this and force the other tables to display their content and ignore the table with empty rows?