Re: can anyone help me?

From: Joe D <joed_at_icoms.com>
Date: Thu, 21 Oct 1999 14:29:52 -0400
Message-ID: <380f5b3b@News.Destek.net>

I found another version of this query, seems someone has been editing things:
seems to me that there are four selected items that aren't associated with any table or view. They are, AMOUNT, TRANSACTION_DATE, FREIGHT, & TRANSACTION_TYPE. (from the create view command).

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 AMOUNT,

T.ORDER_NUMBER, I.INVOICE_DATE, T.ORDER_DATE TRANSACTION_DATE,
I.SALES_AMOUNT, I.TRANSPORT_COST FREIGHT,  I.INVOICE_TYPE TRANSACTION_TYPE,
T.STORE_ID

from INVOICE I, TXORDER T
where T.TXORDER_ID = I.TXORDER_ID Received on Thu Oct 21 1999 - 13:29:52 CDT