if else situation in sql

I have a view that I use at work.

My goal is:

• If "data on row " = 'petrol' then columns should be fetched from "A table inner join B table"

• If "data on row" = 'diesel' then fetch from "C table inner join D table"

Is that possible in same column at the view query? (plsql)

Thanks.