can anyone help me?

From: Joe D <joed_at_icoms.com>
Date: Thu, 21 Oct 1999 13:55:36 -0400
Message-ID: <380f5332@News.Destek.net>

can you find the syntax error here? I can't but sqlplus tells me that:

---

CREATE VIEW REPORT_TRANSACTION_VIEW AS
*
ORA-00933: SQL command not properly ended

---

here is the query that I ran. I did not write it. someone else did but I still can't find the syntax error. Hopefully a fresh pair of eyes will help.

select * from REPORT_TRANSACTION_VIEW
where TRANSACTION_DATE >= :lStarttime and TRANSACTION_DATE <= :lEndtime and STORE_ID =
(select store_id from STORE SS where SS.KEY_STORE_SEQID =
(select V.KEY_STORE_SEQID from REPORT_STORES_VIEW V where NAME =
:szMerchant))

CREATE VIEW REPORT_TRANSACTION_VIEW AS
  select I.INVOICE_NUMBER, T.CURRENCY_CODE, T.SALES_AMOUNT, T.ORDER_NUMBER,  I.INVOICE_DATE, T.ORDER_DATE, I.SALES_AMOUNT, I.TRANSPORT_COST, I.INVOICE_TYPE,
 T.STORE_ID
from INVOICE I, TXORDER T
where T.TXORDER_ID = I.TXORDER_ID;

TIA,
Joe Received on Thu Oct 21 1999 - 12:55:36 CDT