Creating view, showing only data whithout connceted data

[Raphael Nelkel]

Hi,

I have 3 tables:
-object
-order
-report
Each object gets one or several orders. Each order gets one report.

They are connected in the following way:
-order -->objectID

-report -->objectID
-->orderID

Now I want to create a view showing all oders (together with object informations) which not yet have a report (no report in the database is yet connected via foreign key to an order).

What would be the best solution to do this?

Thank you very much!