Order List


select a.POID "Order No", a.POLINENO "Item No", a.Bib_id, b.HEADING_DISPLAY "Title", a.QTYORDERED "Quantity Ordered" from podetail a, title_heading b, title_heading_link c where poid not in (select poid from receipts) and a.bib_id=c.bib_id and b.auth_id=c.auth_id and c.tag_value = '245' and ALTERNATE_TAG = '0' order by a.poid
                                                                                     *
ERROR at line 1:
ORA-00904: "A"."QTYORDERED": invalid identifier