J. If I'm not mistaken you have a couple of ) that seem out of place (see below)
original 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 try this one 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 Jan -----Original Message----- From: J BLAUSTEIN <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 08 Apr 2011 12:54:28 -0400 Subject: [RBASE-L] - Re: Custom colors in report BRUSH_COLOR 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
