Hello All,
I just ran into a rather weird problem in a SQL query. Basically, I
created a view from a very large query. The query runs fine when
executed as is, and the create view statement completes successfully
as well. However, when I try to select from that view I get an error,
"BD Append Not Allowed."
Any ideas about what this means? The query is below.
Thanks,
JLS
SELECT
SUBSCRIPTIONS.ID AS SUBSCRIPTION_ID,
"DBA"."BILLING_ENTITY_MAPPING"."NAME" "SUBSCRIBER",
CHAR(DATE("DBA"."ORDERS"."WHEN"), USA),
"DBA"."BILLING_ADDRESSES"."ADDRESS1",
"DBA"."BILLING_ADDRESSES"."ADDRESS2",
"DBA"."BILLING_ADDRESSES"."ADDRESS3",
"DBA"."BILLING_ADDRESSES"."CITY",
"DBA"."BILLING_ADDRESSES"."STATE",
"DBA"."BILLING_ADDRESSES"."ZIP",
"DBA"."BILLING_ADDRESSES"."COUNTRY",
"DBA"."PEOPLE"."FIRSTNAME" "CONTACT_FIRST_NAME",
"DBA"."PEOPLE"."LASTNAME" "CONTACT_LAST_NAME",
"DBA"."ORGANIZATION_CONTACTS"."WORKPHONE",
"DBA"."ORGANIZATION_CONTACTS"."CELLPHONE",
"DBA"."ORGANIZATION_CONTACTS"."FAX",
"DBA"."ORGANIZATION_CONTACTS"."EMAIL",
(CASE WHEN (ORDERS.QTY >=2) THEN TRUE ELSE FALSE END) AS IS_BUNDLE
FROM
"DBA"."SUBSCRIPTIONS","DBA"."ORDERS","DBA"."BILLING_ENTITY_MAPPING","DBA"."BILLING_ADDRESSES","DBA"."PEOPLE","DBA"."ORGANIZATION_CONTACTS"
WHERE "DBA"."SUBSCRIPTIONS"."ID"= "DBA"."ORDERS"."ITEM"
AND "DBA"."ORDERS"."BILL_TO"= "DBA"."BILLING_ENTITY_MAPPING"."ADDRESS_ID"
AND "DBA"."BILLING_ADDRESSES"."ID"= "DBA"."ORDERS"."BILL_TO"
AND "DBA"."ORDERS"."BILLING_ATTN"= "DBA"."PEOPLE"."ID"
AND "DBA"."ORGANIZATION_CONTACTS"."PERSON_ID"= "DBA"."PEOPLE"."ID"
AND "DBA"."BILLING_ADDRESSES".PERSON_ID IN (SELECT ID FROM ORGANIZATIONS)
UNION ALL
SELECT
SUBSCRIPTIONS.ID AS SUBSCRIPTION_ID,
"DBA"."BILLING_ENTITY_MAPPING"."NAME" "SUBSCRIBER",
CHAR(DATE("DBA"."ORDERS"."WHEN"), USA),
"DBA"."BILLING_ADDRESSES"."ADDRESS1",
"DBA"."BILLING_ADDRESSES"."ADDRESS2",
"DBA"."BILLING_ADDRESSES"."ADDRESS3",
"DBA"."BILLING_ADDRESSES"."CITY",
"DBA"."BILLING_ADDRESSES"."STATE",
"DBA"."BILLING_ADDRESSES"."ZIP",
"DBA"."BILLING_ADDRESSES"."COUNTRY",
"DBA"."PEOPLE"."FIRSTNAME" "CONTACT_FIRST_NAME",
"DBA"."PEOPLE"."LASTNAME" "CONTACT_LAST_NAME",
"DBA"."PEOPLE"."WORKPHONE",
"DBA"."PEOPLE"."CELLPHONE",
"DBA"."PEOPLE"."FAX",
"DBA"."PEOPLE"."EMAIL",
(CASE WHEN (ORDERS.QTY >=2) THEN TRUE ELSE FALSE END) AS IS_BUNDLE
FROM
"DBA"."SUBSCRIPTIONS","DBA"."ORDERS","DBA"."BILLING_ENTITY_MAPPING","DBA"."BILLING_ADDRESSES","DBA"."PEOPLE"
WHERE "DBA"."SUBSCRIPTIONS"."ID"= "DBA"."ORDERS"."ITEM"
AND "DBA"."ORDERS"."BILL_TO"= "DBA"."BILLING_ENTITY_MAPPING"."ADDRESS_ID"
AND "DBA"."BILLING_ADDRESSES"."ID"= "DBA"."ORDERS"."BILL_TO"
AND "DBA"."ORDERS"."BILLING_ATTN"= "DBA"."PEOPLE"."ID"
AND "DBA"."BILLING_ADDRESSES".PERSON_ID IN (SELECT ID FROM PEOPLE)
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
