Challenging query

[mcitpcertify]

Dear Query Gurus,

Hope you are doing great.Its a simple query to retrieve data with the Order_ID.If the record is there its fine and can retrieve the data.

But my query is to retrieve the list of order_id which has no records in database.

Plz help me to write a query.


Thanks

[LKBrwn_DBA]

And you expect us to do your homework?
Have you tried to code the query? What have you got?