You have 5 column names in parenthesis but only pulling 3 columns.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of J BLAUSTEIN Sent: Friday, April 08, 2011 11:54 AM To: RBASE-L Mailing List 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
