correction
I am trying to create a view from two other views
view 1) invnum,invdate,sale
view 2) invnum,transdate,payment
I would like a combine view with both the invoice total and payments
I have used the below code and have an errror msg invnum not a table
DROP VIEW VWA9iInvHIST
CREATE VIEW `VWA9iInvHIST` (INVNUM,INVDATE,SALE,TRANSDATE,PAYMENT) AS +
SELECT INVNUM,INVDATE,SALE FROM VWINVTOT +
UNION SELECT INVNUM,NULL,0 FROM VWA9InvPmt WHERE INVNUM NOT IN (SELECT
INVNUM FROM VWINVTOT)
RETURN
thanks for your help
--
*J. Blaustein*
*J Blaustein Associates, Inc.*
* 12 Herrick Drive*
* Lawrence, NY 11559*
*516-371-3445 FAX 516-345-8009*
