displays all data with certain field types, from the results of the query [closed]

displays all data with certain field types, from the results of the query … I do queries in three tables, and only show data that has relations only, whereas I want to display everything even though there is no relation …

the data that I have

I want to display the data as below

Answer

You need to use left join in this case