The following link states that orders for books that have not been received is accessed by the aqorders for which datereceived is Null: Acquisition Reports - SQL Library

But this SQL query also makes use of the column biblio. Will record of an item exist in the biblio and biblioitems table before that item is received by the library?

I understood that biblio and biblioitems are created after catalogging a book.

Regards