SELECT tblpublication.publicationid,
tblpublication.publicationtitle,
tblpublication.volume,
tblpublication.numberofvolumes,
tblpublication.catalognumber,
tblpublication.yearpublished,
tblpublication.pages,
tblpublication.edition,
tblpublication.printing,
tblpublication.coverphotolink,
tblpublication.comments,
tblpublication.mediaconditionid,
tblpublication.publisherid,
tblpublication.mediatypeid,
tblpublication.isbn,
tblpublication.confidencelevel,
tblpublication.interalcomments,
tblpublication.shelfid,
tblpublication.listprice
FROM tblpublication
WHERE Iif(Tempvarslong("lngpublicationid") = 0, 0, [publicationid]) )
IN (0, Tempvarslong("lngpublicationid")
ORDER BY tblpublication.publicationtitle;